Hi
I'm new to Hibernate, and want to convert my SQL query to Hibernate query (Criteria/HQL/?):
Code:
select temp.a,temp.b,temp.c,mm.d
from main_table mm, (select count(x) as a, id as b, max(y) c
from main_table where z<100 group by id) temp
where mm.id=temp.id and mm.id not (select id from deleted_main)
Above is an example query in SQL, which I want to convert in Hibernate criteria mainly since as much I read we can't have a query in from clause in HQL.
Could someone please help me in structuring a DetachedCriteria query for above Sql?
TIA
Nitin
Login
FAQ
Search