I want to use unique keyword in createQuery method, but everytime it is giving an parsing error. How can i use it?

Plz help..

Is your intent to remove duplicate rows?

How about DISTINCT instead of unique?

Budyanto

I dont know how to to do it hibernate. But through java u can do like this.

Query q= session.createQuery("some qiery);

List l = q.list();

Set set = new HashSet(list);

Now set contains all the elements.

Hi iam supriyo,

Use HQL .Simply type select distinct column from table
Column and table for your understanding