Hibernate subquery join using Criteria

I recently needed to create max query in hibernate returning an object instead of the maximal value of the field and I wanted to do this using Hibernate Criteria in our JPA environment.
A simple example of what I wanted:

select *
from user
where userid = (select max(userid)
                from user
                where company = 'aCompanyName')

The way to program this in JPA/Hibernate using Criterias, DetachedCriteria and Subqueries. Make sure to use Subqueries.propertyEq instead of Subqueries.eq if you want to join on a field:

public User getMaxUserOfCompany(String companyName) {
 Session session = (Session) em.getDelegate();
 DetachedCriteria subCriteria = DetachedCriteria.forClass(User.class);
 subCriteria.add(Restrictions.eq("company", companyName));
 subCriteria.setProjection(Projections.max("userid") );
 Criteria criteria = session.createCriteria(User.class);
 criteria.add(Subqueries.propertyEq("userid", subCriteria));
 return (User) criteria.uniqueResult();
}