MS-SQL Server的查询语句换成oracle 怎么写？？ #### 100%结贴
select listId from (
select *,row_number() over (partition by listId order by Td desc) as num from #a
) a where result =58 and num=1
select listId基本上差不多额
from (select a.*,
row_number() over(partition by listId order by Td desc) as num
from a) b
where result = 58
and num = 1
