In our last Hibernate lesson, you learned how to fix duplicate data from hibernate queries.

In this lesson we’re going to focus on some of theaggregate functions that can be used with Hibernate, and of course that means diving into theGroup By clause.

What’s important to note is that Hibernate doesn’t ever refer to it as group by, instead they use the term projections.

So, armed with this knowledge, let’s jump into the lesson!

Grouping Data with Hibernate

In our examples, I’m going to show you how to create a query with hibernate that will group your data in some manner.

When we build our query, we will be focusing on using Hibernate’s Criteria queries, which allows for a nice way to build queries without having to know any SQL.

First, let’s start off with an example that we will build on.

...continue reading.