帮我看看这条sql语句该这么写，分组查询，结果正解立即结贴

[xiaohu8855]

with t as (select 1 "TID",1 "PID", 3 "STEPNO" from dual
union all select 2 ,2 , 1 from dual
union all select 3 ,2 , 2 from dual
union all select 4 ,3 , 4 from dual
union all select 5 ,3 , 5 from dual
union all select 6 ,4 , 6 from dual)

要求，在pid 相同的情况下，找出stepno最大的项对应的tid

[xiaohu8855]

自己结贴了
select * from task tt where (tt.pid,tt.stepno) in (select t.pid,max(stepno) from task t group by t.pid )

[Phoenix_99]

select max(tid),pid,max(stepno) from t group by pid

[cosio]

select max(tid),pid,max(stepno) from t group by pid

[xiaohu8855]

我写错了，那个tid是uuid类型的，不能比较大小的

[Phoenix_99]

with t as (
select 1 "TID",1 "PID", 3 "STEPNO" from dual  
union all select 2 ,2 , 1 from dual
union all select 3 ,2 , 2 from dual
union all select 4 ,3 , 4 from dual
union all select 5 ,3 , 5 from dual
union all select 6 ,4 , 6 from dual)

select tid,pid,stepno from(
select tid,pid,stepno,row_number() over(partition by pid order by stepno desc) rn from t
) where rn = 1 

[taotie1225]

自己结贴

[kyle7788]

[Quote=引用 5 楼 phoenix_99 的回复:]
SQL code
with t as (
select 1 "TID",1 "PID", 3 "STEPNO" from dual
union all select 2 ,2 , 1 from dual
union all select 3 ,2 , 2 from dual
union all select 4 ,3 , 4 from dual
union all select 5……
[/Quote]
学习!