如果有这种类似的错误,去查询语句中着重看一下,order by去掉,一般是这个有冲突
消息 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 冲突