Here is the sample code.

Criteria crit = session.createCriteria(Product.class);
crit.add(Restrictions.gt("price",new Double(1.0)));
crit.add(Restrictions.like("name","P%"));
crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

What does Criteria.DISTINCT_ROOT_ENTITY do ?

Regards,
Rohit

It inspects the resultset and insures that the resulting resultset does only contain distinct entities. Does exactly the same as HQL distinct function, only DISTINCT_ROOT_ENTITY does it in java. It's pretty usefull in some situations you can't use distinct in your HQL.

Thanks.