Erp100论坛 » Oracle ERP DBA + Oracle Database » Oracle开发 » 问一个sql查询的语句

xiangzhao 发表于 2008-7-12 14:11

问一个sql查询的语句

sql中怎么用一条ＳＱＬ语句取出第３１条至４０条记录，ＩＤ主键不是连贯的．

xiangzhao 发表于 2008-7-12 14:11

select * from table_name where rownum<41
    minus
    select * from table_name where rownum<31;

xiangzhao 发表于 2008-7-12 14:11

select * from (select rownum x,table_name.* from employees) where x between 31 and 40;
/

xiangzhao 发表于 2008-7-12 14:11

试试这个
select * from
(select id, name ,row_number() over (order by id) idx
from table_A)
where idx >= 31
and idx <= 40;

查看完整版本: 问一个sql查询的语句