java - 将 SQL hibernate 到 HQL

Question

我在尝试将 SQL 查询转换为 HQL(或标准/限制)时遇到了一些问题。我有以下 SQL 查询:

Select count(n), CreatedDate from (
  Select count(serverId) as n, Date(Created) as CreatedDate 
  from mytable 
  group by Date(Created), serverId
) as tbl 
group by CreatedDate;

那么什么是 HQL(或标准)等价物？

Answer 1

某些 SQL 查询无法直接转换为 HSQL，但这可能会有所帮助:HQL Subqueries in joins