hi,

i do not know how to do the group by and having by using the criteria.

i have to solve the following query using criteria.

"select EmployeeNo from employee group by projectid having projectid=1"

please give the answer.

Thanks.

You need to use projections to do this because there is no explicit "group by" necessary in a criteria query. Certain projection types are defined to be grouping projections, which also appear in the SQL group by clause.

An alias can be assigned to a projection so that the projected value can be referred to in restrictions or orderings.

Here are two different ways to do this:

List results = session.createCriteria(Cat.class)
.setProjection( Projections.groupProperty("color").as("colr") )
.addOrder( Order.asc("colr") )
.list();