select user_nm , max(seq) seq from tb group by user_nm --你的结果错了吧.
--最大 select user_nm , max(seq) seq from tb group by user_nm --最小 select user_nm , min(seq) seq from tb group by user_nm
select user_nm,seq from (select user_nm,seq,row_number() over(partition by user_num oder by seq desc) rn from table) where rn = 1;或者select user_nm,seq from table a where not exists (select 1 from table b where b.user_nm = a.user_nm and b.seq > a.seq);
那就是#3中: 第一段sql去掉desc或者 第二段sql>改为<
select user_nm,seq from (select user_nm,seq,row_number() over(partition by user_num oder by seq desc) rn from table) where rn = 1;
select user_nm , max(seq) seq from tb group by user_nm --最小
select user_nm , min(seq) seq from tb group by user_nm
where rn = 1;或者select user_nm,seq from table a where not exists (select 1 from table b where b.user_nm = a.user_nm and b.seq > a.seq);
第一段sql去掉desc或者 第二段sql>改为<
where rn = 1;