取特定记录条数???????/

[summerCsdn]

select 查询时,有2000条记录符合条件,如何先取出符合条件前1000条,然后再取出符合条件的后1000条??????????

[jiezhi]

select * from table1 where .... and rownum<=1000;
select * from (select rownum rn a.* from table1 a where ... )
order by rn desc and rn<=1000;

[jiezhi]

不好意思写错了：
select * from (select rownum rn a.* from table1 a where ... )
where rn<=1000;
order by rn desc

[beckhambobo]

select * from (select rownum rm.....where....order by..) where rm<=1000;

select * from (select rownum rm.....where....order by..) where rm>1000 and rm<=2000;

一条语句不懂写:(

[summerCsdn]

楼上的的朋友,取前1000条可以,取后面1000条进取不出,为什么?

[summerCsdn]

楼上的的朋友,取前1000条可以,取后面1000条时取不出,为什么?

[戚爱斌]

select * from (select rownum rm.....where....order by..) where rm<=2000 minus
select * from (select rownum rm.....where....order by..) where rm<=1000 and rm<=1000;

[summerCsdn]

ok. xie xie