Hibernate Community • View topic - Convert SQL query to HQL query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Convert SQL query to HQL query

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

inter7

Post subject: Convert SQL query to HQL query

Posted: Fri Mar 05, 2010 7:48 am

Newbie

Joined: Thu Oct 25, 2007 10:24 am
Posts: 2

Hi all.

I need some help to convert this SQL query to HQL:

Code:

select c1.code, count(*) 
from (select min(myDate) as myDate,serialNumber,code from TableXpto
where actual_state ='OK' group by serialNumber) as c1 
where c1.myDate >= '2009-01-01' and c1.myDate <= '2010-03-20' 
group by c1.code

If you take a look you see that i have one sub query and that's why i'm having problems to convert this query.

Thx for your help.

Top

inter7

Post subject: Re: Convert SQL query to HQL query

Posted: Mon Mar 08, 2010 5:10 am