Share on Google+Share on Google+

HQL Group By Clause Example

Group by clause is used to return the aggregate values by grouping on returned component. HQL supports Group By Clause.

HQL Group By Clause Example


Group by clause is used to return the aggregate values by grouping on returned component. HQL supports Group By Clause. In our example we will calculate the sum of invested amount in each insurance type. Here is the java code for calculating the invested amount insurance wise:




package roseindia.tutorial.hibernate;
import org.hibernate.Session;
import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
 @author Deepak Kumar
HQL Group by Clause Example

public class HQLGroupByExample {
  public static void main(String[] args) {
  Session session = null;
  try {
  // This step will read 
hibernate.cfg.xml and prepare hibernate for

  // use
  SessionFactory sessionFactory = 
new Configuration().configure()
  session = sessionFactory.openSession();
  //Group By Clause Example
  String SQL_QUERY = "select sum
insurance.insuranceName "

  "from Insurance insurance 
group by insurance.insuranceName"
 Query query = session.createQuery(SQL_QUERY);
 for (Iterator it = 
(); it.hasNext();) {
 Object[] row = (Object[]);
Invested Amount: " 
+ row[0]);
Insurance Name: " 
+ row[1]);
  catch (Exception e) {
  finally {

To run the example select Run-> Run As -> Java Application from the menu bar. Following out is displayed in the Eclipse console:

Hibernate: select sum(insurance0_.invested_amount) as col_0_0_, insurance0_.insurance_name as col_1_0_ from insurance insurance0_ group by insurance0_.insurance_name

Invested Amount: 3500

Insurance Name: Car Insurance

Invested Amount: 500

Insurance Name: Dental Insurance

Invested Amount: 1550

Insurance Name: Home Insurance

Invested Amount: 1500

Insurance Name: Life Insurance

Invested Amount: 1600

Insurance Name: Medical Insurance

Invested Amount: 1680

Insurance Name: Motorcycle Insurance

Invested Amount: 2600

Insurance Name: Travel Insurance



Posted on: January 19, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: HQL Group By Clause Example   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
March 22, 2012

package com.hibernate._4; import java.util.Iterator; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; public class GroupTest { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub Session session = null; try{ SessionFactory factory = new Configuration().configure().buildSessionFactory(); session = factory.openSession(); String SQL_QUERY = "select sum(books.bookPrice)from Books books group by books.bookPrice"; Query query = session.createQuery(SQL_QUERY); for (Iterator it = query.iterate(); it.hasNext();) { Double[] row = (Double[]); System.out.println("Sum: " + row[0]); } session.close(); } catch (Exception e) { System.out.println(e.getMessage()); } finally { } } } this is what i got Hibernate: select sum(books0_.BOOKPRICE) as col_0_0_ from BOOKS books0_ group by books0_.BOOKPRICE java.lang.Double cannot be cast to [Ljava.lang.Double;
Manish Kumar Nayak
May 30, 2012

Hi this is good site.