Set<Health> getLastHealthsByPatient(Patient patient)
	{
		Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Health.class);
		criteria.add(Restrictions.eq("PATIENTID", patient));
		
		DetachedCriteria maxQuery = DetachedCriteria.forClass( Health.class );
		maxQuery.setProjection( Projections.max( "TIMESTAMP" ) );
		criteria.add( Property.forName( "TIMESTAMP" ).eq( maxQuery ) );
		
		
		return (Set<Health>)criteria.list();			
	}	

SELECT id, value, max(date), type, value FROM health GROUP BY type

select * from Table1 t1
where not exists (
  select * from Table1 t2
  where t2.type = t1.type
  and t2.date>t1.date
)

select * from health t1
where not exists (
  select * from health t2
  where t2.type = t1.type
  and t2.date>t1.date
)

  CREATE TABLE "HEALTH" 
   (	"ID" NUMBER, 
	"TYPE" VARCHAR2(20 BYTE), 
	"VALUE" FLOAT(126), 
	"TIMESTAMP" TIMESTAMP (6), 
	"PATIENTID" NUMBER
   );
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('0','weight','85,6',to_timestamp('2012.03.31 10:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('1','height','186',to_timestamp('2012.03.31 00:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('2','SBP','120',to_timestamp('2012.03.31 00:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('3','DBP','80',to_timestamp('2012.03.31 00:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('4','weight','85,1',to_timestamp('2012.03.31 20:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('5','weight','87,1',to_timestamp('2012.04.01 12:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'0');
Insert into HEALTH (ID,TYPE,VALUE,TIMESTAMP,PATIENTID) values ('6','weight','87,1',to_timestamp('2012.04.01 12:00:00,000000000','RRRR.MM.DD HH24:MI:SS,FF'),'1');

select * from health t1
where not exists (
  select * from health t2
  where t2.type = t1.type
  and t2.timestamp>t1.timestamp
)

SELECT id, type, value, timestamp, patientid FROM health WHERE timestamp=(SELECT max(timestamp) FROM health) GROUP BY type

select id, timestamp, type
from health 
group by type 
having timestamp = max(timestamp)

SELECT *
FROM health
INNER JOIN 
(SELECT type, MAX(timestamp) as TopDate
FROM health
GROUP BY type) AS EachItem ON 
    EachItem.TopDate = Table.timestamp 
    AND EachItem.type = Table.type

SELECT
  id,
  type,
  MAX(timestamp) AS "MostRecentServiceMonth"
FROM health
GROUP BY id, type

select * from health
where type and timestamp in (SELECT type, max(timestamp) FROM health GROUP BY type)

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