面试题

选取30行之后的十行数据，eg:

1 SELECT TOP (10) id, title, datetime, author, cont
2 FROM tb_news
3 WHERE (id NOT IN
4 (SELECT TOP (30) id
5 FROM tb_news AS tb_news_1))

不要使用如下代码：

1 SELECT TOP (40) id, title, datetime, author, cont
2 FROM tb_news
3 WHERE (id NOT IN
4 (SELECT TOP (30) id
5 FROM tb_news AS tb_news_1))

这样就选取除了30行之外的下40行数据，别理解错了。

转载于:https://www.cnblogs.com/shoushangdeyu/p/4452555.html