sort order
The rule that decides the order in which results are returned, such as newest first.
In more detail
Databases do not guarantee any order unless asked, so clients that page through results need an explicit sort to avoid missing or repeating rows. Sort by a unique column, or add one as a tie breaker, so every page is well defined.
Related terms
- pagination — Splitting a large collection into bounded pages, each with a way to ask for the next one.
Taught in
- Spring Data Repositories — Modern Java: Virtual Threads & High-Throughput Services