2017年6月8日
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
摘要： Sorting the view based on frequency in SQL Server Just like in sub queries, you can't use ORDER BY in a view definition in sql server unless you also 阅读全文
posted @ 2017-06-08 11:21 ChuckLu 阅读(2782) 评论(0) 推荐(0) 编辑