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

Taught in

References