Hi,
how to implement in hibernate criteria sql query like (i.e.):
select distinct on (id) * FROM clock WHERE group='old' ORDER BY id, time;
?
Distinct is only on 'id' parameter, but before distinct data is sorted by time.
Thx.
Junior Member
Hibernate criteria [select distinct order by]
Hi,
how to implement in hibernate criteria sql query like (i.e.):
select distinct on (id) * FROM clock WHERE group='old' ORDER BY id, time;
?
Distinct is only on 'id' parameter, but before distinct data is sorted by time.
Thx.
Posting Permissions
Reply With Quote