sql读取 数据问题

[sklkitty]

如题：sql读取 数据问题


查询前4条数据是 select top 4 * from table 假设结果是 1,2,3，4
现在我想查前4条数据后的5条数据 结果是 5，6,7,8,9 请问这样SQL语句怎么写呢？？？
请哪位大侠帮个忙。十分谢谢。

[我姓区不姓区]

select top 5 * from table where 列名 >4

[myhope88]

select top 5 * from table where id not in (select top 4 id from table)
其中id须为自动增长的

[guyehanxinlei]

http://www.cnblogs.com/biacbo/archive/2010/01/29/1659089.html

[HolyPlace]

select top 5 * from table where [id] not in (select top 4 [id] from table)

[路人乙e]

select top 5 * from (select top 9 * from table order by id) order by id desc

[沈勇]

select top 5 * from table order by id desc where id not in(select top 5 * from table order by id desc)
id按照升序排列

[huangmin3956]

[Quote=引用 4 楼 holyplace 的回复:]
select top 5 * from table where [id] not in (select top 4 [id] from table)
[/Quote]up

[eagle4125]

路过，顶下

[sklkitty]

非常谢谢 各位的解答 问题解决了。

[大明湖畔_帅锅]

jf

[sk_sakula]

取前9条数据，然后反序取top 5