sql查找出数据表中第30到第40条记录

[tankey0909]

有字段ID ,但id不连续

[u010412956]

select t.* from (select t.*, rownum rn from emp t) t where rn between 30 and 40;

[cappuccinno]

恩。。楼上几个回答了- -果断用 rownum select rn,order_id,order_name from (select rownum rn ,order_id,order_name from testdata) where rn between 2 and 3;

[LCore]

引用 楼主 tankey0909 的回复:

有字段ID ,但id不连续

用rownum select * from emp where rownum<=40 minus select * from emp where rownum<=30