How to Implement GROUP BY Clause using Hibernate Criteria?

Hibernate Group by Criteria Object

To achieve a SQL query with a group by clause using Hibernate Criteria, it is crucial to utilize the groupProperty() method. The following code demonstrates how to implement such a query:

SELECT column_name, max(column_name) , min (column_name) , count(column_name)
FROM table_name
WHERE column_name > xxxxx
GROUP BY column_name

The corresponding Hibernate Criteria object would be:

List result = session.createCriteria(SomeTable.class)
                    .add(Restrictions.gt("someColumn", xxxxx))
                    .setProjection(Projections.projectionList()
                            .add(Projections.groupProperty("someColumn"))
                            .add(Projections.max("someColumn"))
                            .add(Projections.min("someColumn"))
                            .add(Projections.count("someColumn"))  )
                    .list();

The groupProperty() method specifies the column on which to group the results, while the Projections class provides aggregate functions such as max(), min(), and count(). By utilizing these methods, it is possible to perform complex data aggregation operations using Hibernate Criteria.

The above is the detailed content of How to Implement GROUP BY Clause using Hibernate Criteria?. For more information, please follow other related articles on the PHP Chinese website!