Sorting the results

In SQL, we use the ORDER BY clause to sort a result by column name and either ascending or descending order. We can achieve the same thing in hibernate as well.

How to do it…

Let's suppose that we selected all the records from the employee table, and then, by default, the records were sorted by the primary key column. But now, we want all the records to be sorted by the descending order of firstName.

Now, the scenario is to select all the employees and order them using their first name.

The equivalent SQL query to do this is is as follows:

SELECT * FROM employee ORDER BY firstName DESC;

Consider the following table data for this recipe:

department	salary	firstName	id
1	50000	Yogesh	1
1	35000	Aarush	2
3	30000	Varsha	3
2	75000	Vishal	4

Let's take a look at how to achieve such a condition in hibernate:

Code

Enter the following code to sort the results according to the employee's first name:

Criteria criteria = session.createCriteria...

The rest of the chapter is locked

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Renews at £13.99/month. Cancel anytime

Start free trial

Previous Chapter

Chapter 1 of 15

Next Chapter