Hibernate Community • View topic - How to project in HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to project in HQL

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Pat Nevin

Post subject: How to project in HQL

Posted: Thu Jan 28, 2010 12:53 am

Newbie

Joined: Wed Jan 27, 2010 9:20 pm
Posts: 2

Hi am totally new to Hibernate, and have an SQL statement that I need to convert into HQL hope someone can please help?

SQL Statement

Quote:

SELECT max(SenseValue)-min(SenseValue)
FROM IODeviceData
WHERE NetworkID= 80
AND IODeviceID=129
AND SenseDate >= '2010-01-01' /**etc.**/
AND SenseDate <= getDate()

And have got so far in HQL without errors... (am using Netbeans6.8 to run HQL statements)

Quote:

from IodeviceData
WHERE NetworkID=80
AND IODeviceID=129
AND SenseDate >= '2010-01-01'
AND SenseDate <= GETDATE()

However am unable to use the SELECT to project just the needed values as in when i add following keep getting errors:

Quote:

SELECT max(SenseValue)-min(SenseValue)

Hope someone can help me to find the max-min value?? thanks

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum