[Err] 42000 - [SQL Server]ORDER BY 子句中的列 “t_xxx.inputDate” 无效,因为该列没有包含在聚合函数或 GROUP BY 子
错误sql,导致了上面的错误
select count(1) from t_xxx q order by q.inputDate desc
下面是可以正常运行的slq
select top 10 inputDate,* from t_xxx q order by q.inputDate desc
[Err] 42000 - [SQL Server]ORDER BY 子句中的列 “t_xxx.inputDate” 无效,因为该列没有包含在聚合函数或 GROUP BY 子
错误sql,导致了上面的错误
select count(1) from t_xxx q order by q.inputDate desc
下面是可以正常运行的slq
select top 10 inputDate,* from t_xxx q order by q.inputDate desc