Sort rows with a stable order
The shop manager wants expensive orders first. Choose a sort direction and break ties between equal amounts so the result stays predictable when several orders have the same price.
ORDER BY arranges the result; ASC goes up, DESC goes down, and another key breaks ties.
- ORDER BY
- Sets the order of result rows using one or more keys.