Skip to main content
Sorting lets you control the order in which query results are returned. To sort records in a Standard table, place the sort keywords between the find conditions and the limit in your query:

​
Sort Keywords

ASC

Sort Ascending — orders results from A to Z (or lowest to highest for numeric values).

DESC

Sort Descending — orders results from Z to A (or highest to lowest for numeric values).

​
Syntax

Combine SORT BY with LIMIT to efficiently retrieve a ranked subset of records — for example, the five most recent entries or the top-priced items.