SQL语句:
select * from (select col, rownum rowcount from table where rownum<=20) where rowcount>=10;
select * from (select col, rownum rowcount from table where rownum<=20) where rowcount>=10;
是列还是oracle里的特殊列
这里有一个通用的: (只要是按id索引的 )
select * from TABLENAME p where
10 < (select count(*) from TABLENAME where TABLENAME.id > p.id) and
21 > (select count(*) from TABLENAME where TABLENAME.id > p.id)
当然有的话可以直接一些.
只要有索引就行.
就像上面的sql语句
10 < (select count(*) from TABLENAME where TABLENAME.id > p.id) and
21 > (select count(*) from TABLENAME where TABLENAME.id > p.id) 这个语句只不知道效率如何?