java - 使用 HQL 从(选择...)中选择

Question

如何在 Hibernate HQL 中编写以下内容？

SELECT * 
FROM   (SELECT * 
        FROM   example_table 
        ORDER  BY table_date DESC) AS oo 
GROUP  BY table_date; 

HQL:

SELECT o 
FROM   (SELECT op 
        FROM   example_table op 
        ORDER  BY table_date DESC) o 
GROUP  BY table_date DESC; 

我遇到的错误

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: 
( near line 1, column 15 [SELECT o FROM (SELECT op FROM za.co.paygate.intranet.database.model.FinTrans op WHERE clientId = :clientId AND finTransDate BETWEEN :monthStart AND :monthEnd ORDER BY finTransDate DESC) o GROUP BY clientTermId];
 nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token:
 ( near line 1, column 15 [SELECT o FROM (SELECT op FROM za.co.paygate.intranet.database.model.FinTrans op WHERE clientId = :clientId AND finTransDate BETWEEN :monthStart AND :monthEnd ORDER BY finTransDate DESC) o GROUP BY clientTermId]

Answer 1

这不是标准的 HQL。您使用的是 native SQL。因此，在代码中使用 createSQLQuery 代替 createQuery 进行查询。