JPA - getting distinct value from one column

Question

I have an entity that has few fields. One of them is city name. Now I want to get list of all distinct cities from that table. How can I archive that. I tried using DISTINCT keyword, but it doesn't work.

I'm using Hibernate as JPA provider but I would like to get it in pure JPA Query.

Answer 1

use Distinct criteria or go for distinct aggregate function

edit:
added simple snippet from here

String queryString = "select distinct f from Foo f inner join foo.bars as b" +
                " where f.creationDate >= ? and f.creationDate < ? and b.bar = ?";
        return getHibernateTemplate().find(queryString, new Object[] {startDate, endDate, bar});

Answer 2

Have you tried:

SELECT DISTINCT t.city FROM MyTable t