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.

score 2 · Accepted Answer · answered Aug 30 '10 at 13:55

2

Have you tried:

SELECT DISTINCT t.city FROM MyTable t

answered Aug 30 '10 at 13:55

mtpettyp

5,455
1
31
33

Yes, but it threw an exception that there is no [id] so an object cannot be created. – Migol Aug 31 '10 at 11:12
This sounds like an issue with your entity. Does it have a PK? – mtpettyp Aug 31 '10 at 11:27

JPA - getting distinct value from one column

1 Answers1

Linked