ORACLE 当中有三到四条数据.
SQL怎么写..才能.分别取得,,第二条..第三条.第四条数据.
第一条.. selest t.* from AA where rownum = 1
第二条.. SQL 怎么写?
第三条.. ....?
第四条.. ....?
SQL怎么写..才能.分别取得,,第二条..第三条.第四条数据.
第一条.. selest t.* from AA where rownum = 1
第二条.. SQL 怎么写?
第三条.. ....?
第四条.. ....?
selest t.* from AA where rownum = 3;selest t.* from AA where rownum = 4;
minus
selest t.* from AA where rownum <= 1;
...
selest t.* from AA where rownum <= n;
minus
selest t.* from AA where rownum <= n-1;
select * from
(select rownum rn,t.* from aa t where rownum<=3) tt
where rn=3;
select * from (select rownum num,AA.* from AA) t where t.num=2
select * from (select rownum num,AA.* from AA) t where t.num=3
select * from (select rownum num,AA.* from AA) t where t.num=4