I am using Criteria API. I want to use the Aggregate Functions likeAvg(),count() etc in the where clause i know its available through Projections but projections used as the slect part of the query i want to use these functions in where clause likecriteria.add(Restriction.eq(Projections.count("emp"),5));

Is there any way to do that.

if the problem is not clear lets say i have two tables Employee and Address and the relation between is one to many Employee have multiple Addresses so i want to retrieve the employee who have 5 or more Addresses.