rownum问题--如何查询表中第90条到100条的记录

[panweiwebweb]

能否讲解一下 rownum？最好来个例子
rownum问题--如何查询表中第90条到100条的记录

[yuyu1980]

select * from
(select rownum jl,a.* from tzb a)
where jl between 90 and 100

或者
select * from tab
where rownum < 100 and not exists
(select 1 from tab where rownum<90)

[yuyu1980]

第二个是错误的

[tgm78]

举个例子

select r,e.* from (select rownum r,last_name,salary from (
select last_name,salary from employees order by nvl(salary,0) desc)) e
where r between 90 and 100;

[pdw2009]

select rw ,e.* from (select rownum rw ,lname,fname from abc where rownum<30) where rw>=0

这样的写法速度才是最快的.
select * from tab where rownum < 101
minus
select * from tab where rownum<89;
minus运算效率太慢了...

[liliang9981]

select * from tab where rownum < 101
minus
select * from tab where rownum<89;

[bj_cash2006]

恩 学习

[dennyjava]

up...

[windyupeng]

select rw ,e.* from (select rownum rw ,lname,fname from abc where rownum<30) where rw>=0


-------------------------

不知道e . 是从那里来的 是abc 这个表吗？

[liujun1979]

select rw ,e.* from (select rownum rw ,lname,fname from abc where rownum<=100 order by lname) where rw>=90

如果表abc有lname的索引，这条SQL就可以取以lname排序的第90到第100行记录。