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!

Answer 1

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)