写一条sql，查询出结果集第20行到第30行的记录，该怎么写？
时间:2012-02-27 16:43
来源:北梦海
作者:西浦恋人
中国法律网
mysql：
select * from 表名 limit 19,10;
oracle:
select * from (select rownum id,a.* from 表名 a) where id between 20 and 30;
---
以上，希望对你有所帮助。
sql server/sybase:
select top 11 * from aaa where id not in (select top 19 id from aaa order by id) order by id
特别的，sql server2005/2008还可以这么写
select * from
(
select Row_Number() over (order by id) as row,* from aaa
) tmp
where row between 20 and 30
oracle:
select * from
(select * from aaa order by id)
where rownum between 20 and 30
楼上的都写对了，赞一个！！
select * from
(
select Row_Number() over (order by id) as row_id,* from aaa
) tmp
where row_id between 20 and 30
(责任编辑：admin) |
------分隔线----------------------------
