HQL查询分组最大记录的问题

[muwooer]

假设一张表TA有三个字段：id，name和date，现在的查询需求是按照name分组，并查出每组里面date字段值最大的记录，如何使用一条hql实现？

[王小胖重新学编程]

SELECT DISTINCT(name), MAX(date) AS date1 FROM TA GROUP BY name

[王小胖重新学编程]

SELECT DISTINCT(name), MAX(date) AS date1 FROM TA GROUP BY name

[王小胖重新学编程]

SELECT DISTINCT(name), MAX(date) AS date1 FROM TA GROUP BY name

[王小胖重新学编程]

SELECT DISTINCT(name), MAX(date) AS date1 FROM TA GROUP BY name

[muwooer]

忘了说了，返回的结果必须是整条记录，也就是id，name和date三个字段。