面试题

选取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行数据，别理解错了。

posted @ 2015-04-24 09:45  我的___爱  阅读(125)  评论(0)    收藏  举报