java - Hibernate last record in group using hibernate criteria -

i have table following fields: id (unique),type, value , createddate

the data types uniqueidentifier,varchar , datetime respectively.

sample data:

id   type  value createddate  ui1 field1 value1 2016-02-13 16:39:21.100  ui2 field1 value2 2016-02-20 18:00:00.100  ui3  field2 value3 2016-02-13 16:39:21.200  ui4  field2 value4 2016-02-20 18:00:00.200 

i need retrieve latest value record each type.

hence expected result should this:

id  type value createddate  ui2  field1 value2 2016-02-20 18:00:00.100  ui4  field2 value4 2016-02-20 18:00:00.200 

i hope carry out sql query. need hsql code achieve this?

use hql query this

from record r  group r.type  having r.createddate >= (     select r2.createddate      record r2      r2.type = r.type )