消息 1033,级别 15 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table
消息 1033,级别 15,状态 1,第 21 行
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.
如果使用 ROW_NUMBER() 分页时报错
去掉: Where 后边的 order by .他和ROW_NUMBER() 里的 order by 冲突