User Comments for the tutorial:

Hibernate Avg() Function (Aggregate Functions)



little mistake in query syntax
There is a little mistake should be avg(insurance.investementAmount) 

HQL Query
I want to retrieve max values of one column for all unique values of another column.Can any one help me to write the HQl query? 

read data from xls sheet
RoseIndian, I want to learn how to retrieve data from xls sheet to the java program 

mapping file for select query
Hi, Could you please give me the mapping and config files for select query. thanks Revathi 

I want to learn how to display data in PDF from java program. 

You must change the query
Change the query as String SQL_QUERY = "select avg (insurance.investementAmount) from Insurance insurance"; So that the above example will be executed.  

probelm in avg
Dear RoseIndia, I m getting error in running the above sample while debugging I m getting error on line List list = query.list(); Kindly let me know is it the issue of compatibility of any installation. Abhishek  

aggregate fundtions not working
Dear sir, I m trying to run the above example but it is going into the exeption after the line List list = query.list(); giving me the following err No data type for node: org.hibernate.hql.ast.AggregateNode [AGGREGATE] Aggregat 

very useful roseindia
Tutorials are very nice and useful to all developers. Thanks to sponsers of this site. 

I love 

Best way
you can modify the code like this package roseindia.tutorial.hibernate; import java.util.Iterator; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernat 

Regarding the Aggregate Functions
Dear Madam, As per the subject line I am trying to Excute the avg aggregate function program but I am facing the problem as Query is SELECT InvestementAmount FROM INSURANCE insurance Exception::No data type for node: org.hibernate.hql.ast.IdentN 

Very good Tutorial 

Related Tutorial and Articles
Hibernate Questions

Hibernate criteria query using avg()
Hibernate criteria query using avg()  How to calculate average in Hibernate criteria query using Projection?   You can calculate average...(employee); } } } Output- Hibernate: select avg 


Hibernate criteria avg.
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... this application it will display message as shown below: Hibernate 

Hibernate Tutorial Example

Hibernate Avg() Function (Aggregate Functions)
Hibernate Avg() Function (Aggregate Functions)  ... to use the avg() function. Hibernate supports multiple aggregate functions. When... query criteria.  Following is a aggregate function (avg() function 


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... avg(numeric_Property_Name) from ClassName Hibernate allows the different 


SQL Avg Syntax
SQL Avg Syntax       SQL Avg Syntax is used to compute the average of the records in a table. Understand with Example The Tutorial illustrate an example from 'SQL Average Syntax 

Hibernate Questions

sum and avg function using HQL.
of all salary : 275000 Hibernate: select avg(employee0_.salary) as col_0_0_ from...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 

Hibernate Questions

Hibernate Query - Hibernate
Hibernate Query  Hibernate Query 

Hibernate Tutorial Example

Hibernate Query Language
).   Understanding HQL Syntax Any Hibernate Query Language may consist... Hibernate Query Language       Hibernate Query Language or HQL for short is extremely powerful 

Hibernate Tutorial Example

Hibernate Count Query
Hibernate Count Query       In this section we will show you, how to use the Count Query. Hibernate... property values of all objects satisfying other query criteria. These functions can 

Hibernate Questions

hibernate query
hibernate query  hibernate apache par kam karta hai kya   Hi Friend, Yes. Thanks