Sorting Records by Constraints in Standard Queries - Standard Computers

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:

[vehicles] <make "Chevy", SORT BY model ASC, LIMIT 5>

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

...SORT BY const_name [ASC || DESC]...

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.