A clause that sorts results by a specified field.
A clause that sorts a result set in ascending (ASC) or descending (DESC) order based on a specified column's values. Specifying multiple columns sorts by priority. Where NULL values land in the sort order (first or last) differs by database product's default behavior, and to guarantee the outcome you actually want, it's safer to state NULLS FIRST or NULLS LAST explicitly rather than rely on the default.
© 2026 ITBGM