怎么取出第10条到第20条记录？

[Alfred]

用一条SQL语句

[点点星灯]

--第10条到第20条记录
select top 10 * from
(select top 20 * from tablename order by desc)
order by id

[playwarcraft]

select top 10 * from T where [某列] not in (select top 20 [某列] from T)

[OracleRoob]

--第11条到第20条，共选出10条记录
select *
from (select top 10 id from (select top 20 id from 表名 order by id) t1 order by id desc) t2
order by id


--从第3条开始的10条记录，共选出10条记录
SELECT top 10 *
FROM 表名
where id>=(select max(id) from (select top 3 id from tb order by id) t1)
ORDER BY id

[Dennis_maomao]

aw511(点点星灯)
wangtiecheng
都是没问题的咯，不过像这种功能在SQL里面处理总是不灵活的，也不常见，一般都是放到程序里面处理，LZ可以考虑下

[hellowork]

select top 11 * from table where id not in(select top 9 id from table order by id)

[wallsshi]

楼上的好严谨，审题审得很认真。

[zhangyanxxxx]

select top 10 * from (select top 20 * From 表名) a order by id desc

[killxtt]

二楼不对吧，选出来的是从20-30的目录
select top 10 * from T where [某列] not in (select top 20 [某列] from T)
应该是
select top 10 * from T where [某列] not in (select top 10 [某列] from T)
吧

[killxtt]

对了，应该还有order by 的语句，漏了

[wilens]

怎么我在SQL Server 2000里用SQL查询分析器执行，老是提示“列名 'id' 无效”。
id应该就是指记录号吧，而不是制定的字段？

[wilens]

没人理，再顶。

[eyumumc]

--第10条到第20条记录
select top 10 * from
(select top 20 * from [table] order by id)
order by id desc