I am trying to do a select distinct for a column in a table. The problem is that the column is part of a composite key so the hibernate query only return one result instead of a list with the different values for that column.

select distinct cn.primaryKey.property from ClassName cn

How can I write the hql to return all values the property have in the database and not just the first value found. Or do I need to use sql?

Greatful for help