Basic

ORDER BY x

x can be any datatype.

NULLs precede non-NULLs.
The default is ASC (lowest to highest)
Strings (VARCHAR, etc) are ordered according the COLLATION of the declaration
ENUMs are ordered by the declaration order of its strings.

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents