Is it possibele to write this SQL statement using HQL?

Question

There is sql statement

select distinct create_date from articles

Is it possibele to write this statement using HQL?

Cheers!

possible duplicate of http://stackoverflow.com/questions/263850/how-do-you-create-a-distinct-query-in-hql — extraneon, Apr 20 '10 at 18:09

score 5 · Accepted Answer · answered Apr 20 '10 at 18:35

5

Yes, it is. HQL supports the DISTINCT keyword.

SELECT DISTINCT a.createDate FROM Article a

I'd propose naming your entity Article (rather than articles) and to use camelCase (rather than under_score)

answered Apr 20 '10 at 18:35

Bozho

1 Answers1