Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HQL for using distinct and other SQL functions

 
Deepaks Deshpande
Ranch Hand
Posts: 114
Eclipse IDE Hibernate Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,
Can anybody give me a solution to write HQL for executing query like



and for other SQL functions like MIN, MAX, COUNT(*) etc. It would be a great help if some one points me to the right links.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The HQL chapter is useful for looking things like this up. For example, they show the following code to use both distinct and count.



 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic