Hibernate query using DISTINCT

valsaraj · **Joined:** Wed Jul 01, 2009 6:19 am **Posts:** 2

Is it possible to find a unique records based on a single filed.

eg: select distinct on (md.STRING01) md.STRING01, md.DATE01 , md.LONG01, md.LONG02, md.LONG03,md.LONG04
from app.MENU md

Can you pls suggest an equivalent hibernate query?

When tried distinct it checks distinct on all fileds. I want to check only one filed and return the latest one when duplictes occurs.

sanjeevsrinath · **Joined:** Tue Jun 30, 2009 7:53 am **Posts:** 4

Yes, it is possible.

Can you try following query:
select distinct(md.STRING01), md.DATE01 , md.LONG01, md.LONG02, md.LONG03,md.LONG04
from app.MENU md

valsaraj · **Joined:** Wed Jul 01, 2009 6:19 am **Posts:** 2

Hi Sanjeev,

Thanks for your reply.

But it worked same as DISTINCT without filed name. DISTINCT(filedname) does not have any effect. So I got more than one field with same name, but unique when considering all fileds.