Hibernate Criteria API for filtering a table rows by min value of its column

Question

How can we implement the following query using Hibernate criteria api

select * from User where date = select min(date) from User

where User have a column named date

Answer 1

You have the Projections class for that which help for all aggregate/groupby stuff. http://www.163jsp.com/help/hibernate32api/org/hibernate/criterion/Projections.html