清山博客

摘要： 执行sql语句:select * from (select * from tab where ID>20 order by userID desc) as a order by date desc逻辑上看着挺对 但是报错:除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。只要我们在嵌套子查询视图里面加入: top 100 percent 即可select * from (select top 100 percent * from tab where ID>20 order by userID desc) 阅读全文

摘要： 执行sql语句:select * from (select * from tab where ID>20 order by userID desc) as a order by date desc逻辑上看着挺对 但是报错:除非另外还指定了 TOP 或 FOR XML，否则，O... 阅读全文