Hi,

I am new to hibernate and trying to create a DetachedCriteria for the following sql statement:

select foreign_key_id from tableX where location = 1 GROUP BY foreign_key_id, rank having count(foreign_key_id) = case rank when 3 then 1 else 2 end

Note: Object name is ObjectX and property names are same as column name

Please let me know, if you want any further info or clarification.

Any help is greatly appreciated.

Thanks

Try using Projections.