SELECT TOP 6 * FROM video ORDER By VideoID DESC
WHERE VideoID not in (SELECT TOP 1 VideoID FROM video Order By VideoID DESC)
...全文
1786打赏收藏
请问得到10条从第二条开始的数据
我的数据库表为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)