请问得到10条从第二条开始的数据

[xiong1000]

我的数据库表为video ，假如有10条数据在里面。
我希望从第2条开始，得到9条数据，其中第1条排除怎么弄？

SELECT TOP 6 * FROM video ORDER By VideoID DESC
WHERE VideoID not in (SELECT TOP 1 VideoID FROM video Order By VideoID DESC)

[xiong1000]

太感谢了。谢谢

[xiong1000]

我上面运行怎么不可以呢？？

[marco08]

--try

SELECT TOP 6 * FROM video
WHERE VideoID not in (SELECT TOP 1 VideoID FROM video Order By VideoID DESC)
ORDER By VideoID DESC

[mengmou]

select top 9 from(
SELECT TOP 10 * FROM video ORDER By VideoID desc)
ORDER By VideoID

[zhenmeiyisi]

select top 10 * from a where id not in(select top 1 id from a) order by id

[caixia615]

SELECT TOP 9 * FROM video ORDER By VideoID DESC
直接这样不就行了啊??