3,478
社区成员




create table t2(c1 varchar2(30),seq varchar2(30));
insert into t2 values('a','1');
insert into t2 values('a','3');
insert into t2 values('a','5');
insert into t2 values('b','1');
insert into t2 values('b','2');
insert into t2 values('b','3');
select c1, seq
from (select t2.*, row_number() over(partition by c1 order by seq) as fn
from t2)
where fn = 2;
select c1, seq
from (select t2.*, row_number() over(partition by c1 order by seq) as fn
from t2)
where fn >= 2;