SQL
`ORDER BY`, `LIMIT` and `OFFSET` Clauses
<div id="rrdiagram8"></div>  
[`ORDER BY`](#docs:sql:query_syntax:orderby), [`LIMIT` and `OFFSET`](#docs:sql:query_syntax:limit) are output modifiers.
Logically they are applied at the very end of the query.
The `ORDER BY` clause sorts the rows on the sorting criteria in either ascending or descending order.
The `LIMIT` clause restricts the amount of rows fetched, while the `OFFSET` clause indicates at which position to start reading the values.