java - 使用Hibernate 'order by' 具有表达式(sum，max，...)的列？

Question

select CONTRACT_ID, sum(PO_SPEND)
from   V_CONTRACT_ANALYSIS_202
group by  CONTRACT_ID 
order by  sum(PO_SPEND) desc

Answer 1

来自hibernate docs

SQL functions and aggregate functions are allowed in the having and order by clauses if they are supported by the underlying database (i.e., not in MySQL).

看起来您正在使用 native SQL 而不是 HQL，但无论如何，您都需要检查数据库供应商文档以查看数据库是否支持按聚合列排序。不过它看起来是正确的。