Question

要查数据表中第30到40条记录，有字段ID，但是ID并不连续，如何写SQL语句？

Answer 1

例：select * from employees e where rownum betwon 30 and 40;

解释：rownum -- 数据库会为出现在查询结果里的记录进行编号，从1开始。

-- 请打印表里的前5行记录
select * from employees where rownum<=5;

-- 请打印表里的第6到第10行记录
select * from employees where rownum between 6 and 10;

注意：对于rownum只能应用 < ，<=， >，>=, =, between XXX and XXX

Answer 2

查SQL安装时的帮助文档。。够全面的、、不嫌麻烦一条条取也可以。。呵呵

Answer 3

mysql：select * from table limit 30,40；oracle：select * from (select * from table a where a.ROWNUM<=40 ) b where b.ROWNUM>=5sqlserverl: select top 10 * from table where id not in (select top 29 id from table)

Answer 4

select * from table where rownum>=30 and rownum<=40

Answer 5

SQLcodeselect* from tb a
where exists ( select 1 from(
select top 10 id from (select topt 40 id from tb order by id desc) as c
)as b where b.id=a.id)