What is Sorting in Spring Data JPA?

Sorting in Spring Data JPA is a feature used to arrange database records in a specific order such as ascending or descending order.

In simple words:

“Sorting organizes records based on one or more fields.”

Why Sorting is Needed

Modern applications display large amounts of data such as:

Products
Students
Interview questions
Orders
Transactions

Without sorting:

Records appear randomly
User experience becomes poor
Finding important data becomes difficult

Sorting improves data organization and readability.

Real-Time Example

E-commerce application may display:

Products sorted by price
Latest orders first
Top-rated products first

Types of Sorting

Spring Data JPA supports:

Ascending sorting
Descending sorting
Multiple field sorting

Ascending Sorting

Arranges records from:

Small → Large
A → Z

Descending Sorting

Arranges records from:

Large → Small
Z → A

Entity Example

@Entity
public class Student {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    private Integer marks;
}

What is Sort Class?

Spring Data JPA provides:

Sort

class to perform sorting operations.

Ascending Sort Example

Sort sort =
        Sort.by("name").ascending();

Descending Sort Example

Sort sort =
        Sort.by("marks").descending();

Repository Example

public interface StudentRepository
        extends JpaRepository<Student, Long> {

}

Find All with Sorting

List<Student> students =
        studentRepository.findAll(
                Sort.by("name")
        );

Generated SQL Query

SELECT *
FROM students
ORDER BY name ASC

Descending Order Example

List<Student> students =
        studentRepository.findAll(
                Sort.by("marks")
                        .descending()
        );

Generated SQL

SELECT *
FROM students
ORDER BY marks DESC

Multiple Field Sorting

Spring Data JPA supports sorting by multiple fields.

Example

Sort sort =
        Sort.by("name")
            .ascending()
            .and(
                Sort.by("marks")
                    .descending()
            );

Generated SQL

SELECT *
FROM students
ORDER BY name ASC,
         marks DESC

Sorting with Pagination

Sorting is commonly used with pagination.

Pagination + Sorting Example

Pageable pageable =
        PageRequest.of(
                0,
                10,
                Sort.by("name").ascending()
        );

Page<Student> students =
        studentRepository.findAll(pageable);

Generated SQL

SELECT *
FROM students
ORDER BY name ASC
LIMIT 10 OFFSET 0

Sorting with Custom Query

Sorting can also be applied in JPQL queries.

JPQL Sorting Example

@Query("""
SELECT s
FROM Student s
ORDER BY s.name ASC
""")
List<Student> getStudentsSorted();

Native Query Sorting Example

@Query(
    value = """
        SELECT *
        FROM students
        ORDER BY marks DESC
    """,
    nativeQuery = true
)
List<Student> getStudentsByMarks();

Dynamic Sorting Example

Users can choose sorting dynamically.

Example

public List<Student> getStudents(
        String field
) {

    return studentRepository.findAll(
            Sort.by(field)
    );
}

REST API Example

@GetMapping("/students")
public List<Student> getStudents(

        @RequestParam String sortBy
) {

    return studentRepository.findAll(
            Sort.by(sortBy)
    );
}

API Request Example


GET /students?sortBy=name

Sorting Directions

Spring Data JPA provides:

Sort.Direction.ASC
Sort.Direction.DESC

Direction Example

Sort.by(
        Sort.Direction.DESC,
        "marks"
)

Case-Insensitive Sorting

Sorting can ignore letter case.

Example

Sort.by("name")
    .ascending()
    .ignoreCase()

Advantages of Sorting

Improves user experience
Better data organization
Easier searching and filtering
Useful for reporting
Enhances frontend display

Disadvantages of Improper Sorting

Slow queries on huge datasets
Performance issues without indexing
Complex sorting logic

Importance of Database Indexing

Sorting large datasets without indexes can:

Reduce database performance
Increase query execution time

Indexed Column Example

CREATE INDEX idx_student_name
ON students(name)

Real-Time Example in E-Commerce Application

E-commerce applications may support:

Price low to high
Newest products first
Highest-rated products

Sorting helps users quickly find products.

Real-Time Example in Interview Portal

Interview portals may sort:

Latest interview questions
Most viewed tutorials
Top-ranked courses

Best Practices for Sorting

Use sorting with pagination
Index frequently sorted columns
Avoid sorting huge datasets unnecessarily
Use dynamic sorting carefully
Validate user-provided sorting fields

Difference Between Sorting and Pagination

Feature	Sorting	Pagination
Purpose	Arrange records	Divide records into pages
Main Classes	Sort	Pageable, Page
Improves	Readability	Performance

Common Interview Questions on Sorting