Hi,
I am trying to write a HQL which fetches data and also constructs the result object as follows:

select new com.test.ResultDTO(c.countryid, c.countryname) from Country c

I need to get all unique countrynames. I tried the following

select new com.test.ResultDTO(c.countryid, distinct(c.countryname)) from Country c
select new com.test.ResultDTO(c.countryid, unieuq(c.countryname)) from Country c

but none seems to work. Can any one let me know how to write HQL for the same?

Regards,
Hari