TOP 和 ORDER BY 同时存在防止超过限定数

SELECT TOP 20 * FROM (SELECT * FROM [tb_News] ORDER BY [NewsCount] DESC)

 

//SELECT TOP 20 * FROM (SELECT * FROM [tb_News] ORDER BY [NewsCount] DESC) AS [%$##@_Alias]

 

上面语句可以准确返回20条.

 

select top 20 * from [tb_News] ORDER BY NewsCount DESC

 

这样的查询如果 NewsCount 有重复的数 会返回多于20条记录