In this section, we will show you, how to use the Min() function. Hibernate supports multiple aggregate functions. When they are used in HQL queries, they return an aggregate value ( such as avg(...), sum(...), min(...), max(...) , count(*), count(...), count(distinct ...), count(all...) ) calculated from property values of all objects satisfying other query criteria.
Following is a aggregate function (min() function) with their respective syntax.
min( [ distinct | all ] object.property)
The Min() function aggregates the minimum value of the given column.
Table Name: insurance
|2||Life Insurance||25000||0000-00-00 00:00:00|
|1||Givan Dhara||20000||2007-07-30 17:29:05|
|3||Life Insurance||500||2005-10-15 00:00:00|
|4||Car Insurance||2500||2005-01-01 00:00:00|
|5||Dental Insurance||500||2004-01-01 00:00:00|
|6||Life Insurance||900||2003-01-01 00:00:00|
|7||Travel Insurance||2000||2005-02-02 00:00:00|
Here is the java code to retrieve the minimum value of "invested_amount" column from insurance table:
|log4j:WARN No appenders
could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select min(insurance0_.invested_amount) as col_0_0_ from insurance insurance0_
Min Invested Amount: 500
Rs. 20,000 US$ 300
Today: Rs. 10,000 US$150
Course Duration: 30 hrs
Posted on: February 27, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles