读书人

怎么选择最后10条记录?

发布时间: 2012-01-12 22:11:58 作者: rapoo

如何选择最后10条记录??

SELECT TOP 10 * FROM (SELECT TOP 10 * FROM article ORDER BY AddTime ASC) ORDER BY AddTime DESC


为什么有语法错

[解决办法]
SELECT TOP 10 * FROM (SELECT TOP 10 * FROM article ) ORDER BY AddTime DESC


为什么有语法错

读书人网 >SQL Server

热点推荐