select * from (select t.*,row_number()over(partition by t.stu_num order by t.s_id desc) rn from view t) where rn=1; 或者用not exists select * from view t where not exists(select 1 from view s where t.stu_num=s.stu_num and t.s_id<s.stu_num)
select * from (select t.*,row_number() over(partition by stuid order by S_ID desc) rn from viewname) where rn=1
(select t.*,row_number()over(partition by t.stu_num order by t.s_id desc) rn from view t) where rn=1;
或者用not exists
select * from view t where not exists(select 1 from view s
where t.stu_num=s.stu_num and t.s_id<s.stu_num)
select * from
(select t.*,row_number() over(partition by stuid order by S_ID desc) rn
from viewname)
where rn=1