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)**

Related Tutorials/Questions & Answers:

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 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. For creating

Advertisements

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) ... 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

SQL Avg Function SQL Avg Function is used to compute the average records value in a column... an example from 'SQL Avg Function'. To understand and grasp the example we

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

JPA Avg Function In this section, you will learn the avg of aggregate function. This method calculate an average of given data. JPA Avg() function:ADS

Using Min, Max and Count on HQL. How to use Min, Max and Count on 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 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

JPA Sum Function In this section, you will learn about sum function of aggregate function of JPQL (Java Persistence Query Language). The sum function to calculate the sum

using function using a function to find the value of v from the foiiowing expression 1v=1u+1*f

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. 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 What is the HQL in hibernate ? Explain the use of HQL. Hi Friend, Please visit on this link....... Hibernate Query Language

Case-insensitive search using Hibernate Query Language(HQL). What is Case-insensitive search using Hibernate Query Language

function like: sum() using hibernate projection. The following example to calculate the sum of invested_amount to the Insurance table ADS_TO_REPLACE_1...Hibernate Projection Example (Sum)

multiplication function in jsp using scriptlet function how...; if(a=="") { alert("insert data"); } } function sum(txt...">--> <script type="text/javascript"> function txtnull

Sum of a Number using Swing In this section, you will learn how to sum of a number using swing...;Calculate.java" to sum of a number using Swing

; sum=sum+s; if(i==n){ System.out.print(s...+"+"); } System.out.print("\nSum of the series : "+sum

Sum of seris Program to find the sum of the following series using a function declaration. sum=x-(xxx)/3!+(xxxxx)/5!-(xxxxxxx)/7!+.....(xx....x)/n!. Where n and x are entered from the keyboard

Find sum of all the elements of matrix using Java A matrix is a rectangular... dimensional array. Now to determine the sum of all these elements, we have initialized a variable sum to 0 and create for loops to iterate throughout the array

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 of two numbers using command line arguments in Java Hi, How...? The calculate the sum of two numbers using command line arguments in Java... = window.adsbygoogle || []).push({}); int sum = a+b; Check complete example code

(); 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

Display Sum of Table Column Using In JSP...;In this Servlet retrieve the data using mysql Query select sum(emp... an application to Display the sum data of a Table column for a specific Date. We

HQL query how to select only password based on username using HQL query from login table where uname and paswrd are two column names

Hibernate min() Function This section contains an example of the HQL min() function. min() function in HQL returns the smallest value from the selected... you how to embed the HQL min() function within your code. In this example

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

In this section, you will learn executing Named HQL written in XML Mapping file

HQL in hibernate ? Explain the use of HQL. What is the HQL in hibernate ? Explain the use of HQL. HQL stands for Hibernate Query...(); Session session = sessionFactory.openSession(); String hql="SELECT

Handle mail function using JSP & Servlet Dear Sir, for my final year project i want to add email function to confirm registration & confirm appointment. I'm using JSP & Servlet and apache web server. I'm developing

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

, The 'SUM' function is used to sum all the values of the specific column of the table... MySQL Aggregate Function This example illustrates how use the aggregate 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 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

columns. But in case of HQL we write queries using the persistence object... the programmer to write Query using the persistence entity. The HQL is fully... using HQL. HQL allows the developers to write queries in object oriented

Find sum of series This section illustrates you how to find the sum of n terms of the series using recursion. For this purpose, we have created a recursive function that takes the parameter 'n' up to which the sum of the series

Hibernate max() Function In this tutorial you will learn about how to use HQL max() function. max() function in HQL returns the largest value from... will demonstrate you how to embed the HQL max() function within your code

Hibernate count() Function In this tutorial you will learn how to use the HQL count() function count() function counts the maximum number of rows.... This function can be simply written with the select clause, however it can be used

HQL Query Hibernate query language: How to use a left join in Hibernate query language. Can somebody help with an example. I am getting a unexpected token error in HQL Query tool If I use joins

Hibernate criteria avg. In this example, you will see the use of avg() method of Criteria class. It returns average value of the given column. Syntax...: select avg(this_.fee) as y0_ from studentinfo this_ Average value of fee

, sum(marks)as total ,avg(marks) as per from stu_table group by stu_id... SQL Avg Group By SQL Avg Group By helps you to find out average value of numeric field

HQL Sample In this site there are many tutorials and example of HQL. These examples comes with HQL sample code that you can download and run on your computer and learn the HQL by modifying and executing these examples. The HQL Sample

HQL order by. HQL Order by query giving problem. Order... into descending order you can follow the following HQL ? (adsbygoogle = window.adsbygoogle || []).push({}); String hql="Select emp FROM Employee emp ORDER

How can we get second of the current time using date function? How can we get second of the current time using date function

HQL group By. How to use group by in HQL? In general...=sessionFactory.openSession(); String hql="Select emp.name FROM Employee emp GROUP BY name"; Query query=session.createQuery(hql); query.setResultTransformer

ModuleNotFoundError: No module named 'Avg_func' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'Avg_func' How to remove the ModuleNotFoundError: No module named 'Avg_func

ModuleNotFoundError: No module named 'Avg_func' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'Avg_func' How to remove the ModuleNotFoundError: No module named 'Avg_func

Ads