sum and avg function using HQL.

sum and avg function using HQL.

How to use sum and avg function in HQL?

View Answers

June 2, 2012 at 6:35 PM

HQL supports many aggregate functions. Sum and avg are some of them.

sum() function returns summation of specified field in the table.

avg() function returns average of specified field in the table.

Example:

package net.roseindia.main;

import net.roseindia.util.HibernateUtil;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class DistinctCountHQL {
    public static void main(String[] args) {
        SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
        Session session = sessionFactory.openSession();
        String sumHql = "Select sum(emp.salary) FROM Employee emp";
        String avgHql = "Select avg(emp.salary) FROM Employee emp";
        Query sumQuery = session.createQuery(sumHql);
        Query avgQuery = session.createQuery(avgHql);
        System.out.println("Sum of all salary : " + sumQuery.list().get(0));
        System.out.println("Average of salary : " + avgQuery.list().get(0));

    }
}

Output:

Hibernate: select sum(employee0_.salary) as col_0_0_ from employee employee0_
Sum of all salary : 275000
Hibernate: select avg(employee0_.salary) as col_0_0_ from employee employee0_
Average of salary : 68750.0

Description: This example calculates sum of salary as- sum(emp.salary) and average of salary as- avg(emp.salary)

Ads









Related Tutorials/Questions & Answers:
sum and avg function using HQL.
sum and avg function using HQL.  How to use sum and avg function in HQL?   HQL supports many aggregate functions. Sum and avg are some of them. sum() function returns summation of specified field in the table
Hibernate avg() Function
Hibernate avg() Function In this tutorial you will learn about the HQL aggregate avg() function in hibernate. An avg() function in HQL performs... that will demonstrate you how to embed the HQL avg() function in between your query
Advertisements
pie chart flex and sum from hql request
pie chart flex and sum from hql request  hi, i work with flex and j2ee project.i have to make a function wich return list of value: print("public... d.intituleDeleg,SUM(s.usagePedag ),ROUND((((SUM(s.usagePedag ))/(SUM(s.ordidispo)))*100),0
Hibernate Avg() Function (Aggregate Functions)
Hibernate Avg() Function (Aggregate Functions)  ... to use the avg() function. Hibernate supports multiple aggregate functions. When they are used in HQL queries, they return an aggregate value ( such as avg
Hibernate criteria query using avg()
Hibernate criteria query using avg()  How to calculate average in Hibernate criteria query using Projection?   You can calculate average of any numeric values in hibernate criteria by using projection. Projection
SQL Avg Function
SQL Avg Function       SQL Avg Function is used to compute the average records value in a column... 'SQL Avg Function'. To understand and grasp the example we create a table 'stu
Using Min, Max and Count on HQL.
Using Min, Max and Count on HQL.  How to use Min, Max and Count on HQL
Delete Query using HQL
Delete Query using HQL  Can we write 'AND' with 'WHERE' clause in delete query using HQL? For example: delete from table name where field1 = value1 and field2 = value2   The example query i have written
using function
using function   using a function to find the value of v from the foiiowing expression 1v=1u+1*f
Using sum() in hibernate criteria.
Using sum() in hibernate criteria.  How to calculate sum() in hibernate criteria by using projection?   You can calculate sum of any numeric value in hibernate criteria by using projection. Projection is an interface
using function
using function  write a program using function overloading to accept any sentence and print vowels and consonants sepratly   Here is an example that accepts a sentence from the user and display the vowels and consonants
Hibernate HQL query by using like operator.
Hibernate HQL query by using like operator.  How use like operator in HQL?   HQL stands for Hibernate Query Language, provided by Hibernate... = sessionFactory.openSession(); String hql="SELECT emp.name, emp.salary, emp.dateOfJoin
HQL
HQL  What is the HQL in hibernate ? Explain the use of HQL.   Hi Friend, Please visit on this link....... Hibernate Query Language
multiplication function in jsp using scriptlet function
multiplication function in jsp using scriptlet function   how...; if(a=="") { alert("insert data"); } } function sum(txt...">--> <script type="text/javascript"> function txtnull
Hibernate Projection Example (Sum)
function like: sum() using hibernate projection.  The following example to calculate the sum of invested_amount to the Insurance table  Table Name...Hibernate Projection Example (Sum)     
Case-insensitive search using Hibernate Query Language(HQL).
Case-insensitive search using Hibernate Query Language(HQL).  What is Case-insensitive search using Hibernate Query Language
Sum of a Number using Swing
Sum of a Number using Swing       In this section, you will learn how to sum of a number using swing...;); Step: Create a file "Calculate.java" to sum of a number using
validation of strings using java function
validation of strings using java function  hi all, i am uploading data from csv file to data base where i took student id as string of length 6 char of the form abc123 will you please give me a function to validate this field
sum
sum  a program to find the sum of the alternative diagit of it ex- no=123456 sum=1+3+5=9
sum
; sum=sum+s; if(i==n){ System.out.print(s...+"+"); } System.out.print("\nSum of the series : "+sum
Sum of two numbers using command line arguments in Java
Sum of two numbers using command line arguments in Java  Hi, How...? The calculate the sum of two numbers using command line arguments in Java... sum = a+b; Check complete example code at Add Two Numbers in Java. Thanks
Hibernate min() Function
Hibernate min() Function This section contains an example of the HQL min() function. min() function in HQL returns the smallest value from the selected... will demonstrate you how to embed the HQL min() function within your code
Display Sum of Table Column Using In JSP
Display Sum of Table Column Using In JSP... an application to Display the sum data of a Table column for a specific Date. We created five file sum_count.jsp, resultForm.jsp, result_count.jsp, sumcount.java
Calculate sum and Average in java
(); int num = Integer.parseInt(data); int sum = 0; float avg...; } avg = sum / num; System.out.println("Sum- " + sum...Calculate sum and Average in java  How to calculate sum and average
Round of to a multiple of 5 without using function
Round of to a multiple of 5 without using function  Please help me out... U enter values like 239, 2543.876, 962.... Give me an equation without using any function which will give output of 240, 2545, 960 respectively
Round of to a multiple of 5 without using function
Round of to a multiple of 5 without using function  Please help me out... U enter values like 239, 2543.876, 962.... Give me an equation without using any function which will give output of 240, 2545, 960 respectively
HQL query
HQL query  how to select only password based on username using HQL query from login table where uname and paswrd are two column names
SQL Aggregate Sum
SQL Aggregate Sum       The SQL Aggregate Sum Function is a part of Aggregate Function that is used to compute sum of the numeric field in a table. Understand
MySQL Aggregate Function
are the Aggregate function: Name Description AVG... | +----------------------+-------------+-------------+ Now, The 'SUM' function is used to sum all... MySQL Aggregate Function   
Hibernate Named HQL using XML Mapping
In this section, you will learn executing Named HQL written in XML Mapping file
ask user how many numbers to be inputted and determine the sum and highest number using an array in java
ask user how many numbers to be inputted and determine the sum and highest number using an array in java  ask user how many numbers to be inputted and determine the sum and highest number using an array in java

Ads