虽然没分。。但还是想问问……

[RunatServer]

SELECT TOP 20
finId,
FROM fin_main
WHERE DateYear = 2006 AND DateMonth = 8 ORDER BY finDateTime ASC
-----返回20条结果

SELECT TOP 40 finId
FROM fin_main WHERE DateYear = 2006 AND DateMonth = 8 ORDER BY finDateTime ASC
-----返回40条结果

SELECT TOP 20
finId,
FROM fin_main
WHERE DateYear = 2006 AND DateMonth = 8 AND
finId NOT IN
(SELECT TOP 40 finId
FROM fin_main WHERE DateYear = 2006 AND DateMonth = 8 ORDER BY finDateTime ASC)
ORDER BY finDateTime ASC
-----返回0条结果

为啥涅？

[RunatServer]

SELECT TOP 20
finId, <----多了个逗号，复制错误而已
FROM fin_main
WHERE DateYear = 2006 AND DateMonth = 8 AND
finId NOT IN
(SELECT TOP 40 finId
FROM fin_main WHERE DateYear = 2006 AND DateMonth = 8 ORDER BY finDateTime ASC)
ORDER BY finDateTime ASC
-----返回0条结果

[RunatServer]

真倒霉，没分的帖子没人光顾。。。

[WangZWang]

说明
SELECT * FROM fin_main
WHERE DateYear = 2006 AND DateMonth = 8
查询出来的记录数<=40条，使用NOT IN
自然没有多余的项目了。