SELECT h.* FROM health h INNER JOIN (SELECT type, MAX(timestamp) AS MaxDateTime FROM health WHERE patientid=0 GROUP BY type) groupedtt ON h.type = groupedtt.type AND h.timestamp = groupedtt.MaxDateTime AND patientid=0

Example ex = Example.create(user);

DetachedCriteria subquery = DetachedCriteria.forClass(Position.class, "last_pos");
subquery.setProjection(Projections.max("last_pos.date"));
subquery.add(Expression.eqProperty("last_pos.userId", "u.id"));

Criteria crit = session.createCriteria(Agent.class, "a")
crit.add(ex);               
crit.createCriteria("positions", "pos");
crit.add(Subqueries.propertyEq("pos.date", subquery));
crit.add(Expression.eq("pos.status", userStatus));

return crit.list();

		Example ex = Example.create(account);

		DetachedCriteria subquery = DetachedCriteria.forClass(Health.class, "last_date");
		subquery.setProjection(Projections.max("last_date.TIMESTAMP"));
		subquery.add(Expression.eqProperty("last_date.PATIENTID", "patient.id"));

		DetachedCriteria subquery = DetachedCriteria.forClass(Health.class, "last_date");
		subquery.setProjection(Projections.max("last_date.TIMESTAMP"));
		subquery.add(Expression.eq("last_date.PATIENTID", "patient.id"));

		Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Patient.class);
		criteria.add(Restrictions.eq("id", new Long(1)));
		criteria.createCriteria("healths", "health");
		criteria.add(Subqueries.eq("health.TIMESTAMP", subquery));

                (Set<Health>) criteria.list();

		DetachedCriteria subquery = DetachedCriteria.forClass(Health.class);
		subquery.setProjection(Projections.max("TIMESTAMP"));
		subquery.add(Expression.eqProperty("PATIENTID", "patient.id"));

		Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Patient.class);
		criteria.add(Restrictions.eq("id", new Long(1)));
		criteria.createCriteria("healths").add(Subqueries.eq("TIMESTAMP", subquery));

		DetachedCriteria subquery = DetachedCriteria.forClass(Health.class);
		subquery.setProjection(Projections.max("timestamp"));
		subquery.add(Expression.eqProperty("patient", "patient.id"));

		Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Patient.class);
		criteria.add(Restrictions.eq("id", Long.valueOf(1)));
		criteria.createCriteria("healths").add(Subqueries.eq("timestamp", subquery));
		criteria.add(Subqueries.eq("timestamp", subquery));

return (Set<Health>) criteria.list();

criteria.createCriteria("healths").add(Subqueries.eq("timestamp", new Date(subquery));

        DetachedCriteria subquery = DetachedCriteria.forClass(Health.class);
        subquery.setProjection(Projections.max("timestamp"));
        subquery.add(Expression.eqProperty("patient", "patient.id"));

        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Health.class);
        criteria.add(Restrictions.eq("patient.id", Long.valueOf(1)));
        criteria.add(Subqueries.propertyEq("timestamp", subquery));

Subqueries.propertiesEq

		return (Set<Health>) sessionFactory.getCurrentSession().createQuery(
				"FROM health a "+
			    "JOIN patient b ON a.patientID = b.patientID " +
			    "JOIN Account c ON b.accountID = c.ID " +
			    "WHERE c.Password='password' " +
			    "AND c.Login='login' " +
			    "ORDER BY a.timestamp desc").list();

sessionFactory.getCurrentSession().createQuery(
				"FROM patient b "+
				"JOIN Account c ON b.accountID = c.ID " +
			    "WHERE c.Password='password' " +
			    "AND c.Login='login' "
				).list()

		return (Set<Health>) sessionFactory.getCurrentSession().createQuery(
				"FROM Health a "+		    
				"WHERE a.patient.account.login='test@mail.com' " +
			    "AND a.patient.account.password='aaaa' "
			    ).list();

		sessionFactory.getCurrentSession().createQuery(
				"FROM Health a "+
				"INNER JOIN "+
						"(SELECT type, MAX(timestamp) AS MaxDateTime FROM a WHERE a.patient.account.login='test@mail.com' " +
					    "AND a.patient.account.password='aaaa' " +
						"BY type) groupedtt " +
					    "ON a.type = groupedtt.type "+
						"AND a.timestamp = groupedtt.MaxDateTime " +			    
				"WHERE a.patient.account.login='test@mail.com' " +
			    "AND a.patient.account.password='aaaa' "
			    ).list()

SELECT h.* FROM health h INNER JOIN (SELECT type, MAX(timestamp) AS MaxDateTime FROM health WHERE patientid=0 GROUP BY type) groupedtt ON h.type = groupedtt.type AND h.timestamp = groupedtt.MaxDateTime AND patientid=0

sessionFactory.getCurrentSession().createQuery(
				"FROM Health a "+
				"INNER JOIN "+
						"SELECT type, MAX(timestamp) AS MaxDateTime FROM a WHERE a.patient.account.login='test@mail.com' " +
					    "AND a.patient.account.password='aaaa' " +
						"BY type groupedtt " +
					    "ON a.type = groupedtt.type "+
						"AND a.timestamp = groupedtt.MaxDateTime " +			    
				"WHERE a.patient.account.login='test@mail.com' " +
			    "AND a.patient.account.password='aaaa' "
			    ).list()

sessionFactory.getCurrentSession().createQuery(
				"FROM Health a "+
				"INNER JOIN "+
						"SELECT type, MAX(timestamp) AS MaxDateTime FROM a WHERE a.patient.account.login='test@mail.com' " +
					    "AND a.patient.account.password='aaaa' " +
						" GROUP BY type groupedtt " +
					    "ON a.type = groupedtt.type "+
						"AND a.timestamp = groupedtt.MaxDateTime " +			    
				"WHERE a.patient.account.login='test@mail.com' " +
			    "AND a.patient.account.password='aaaa' "
			    ).list()