sqlcmd.net validated sql reference

Tag archive

#sort

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly
intermediate sorting MySQL MariaDB SQL Server PostgreSQL SQLite

Control Where NULLs Appear in a Sort

Use `NULLS FIRST` or `NULLS LAST` to explicitly position NULL values at the top or bottom of a sorted result set.

intermediate sorting MySQL MariaDB SQL Server PostgreSQL SQLite

Sort Rows By A Custom Expression

Use a `CASE` expression in `ORDER BY` to apply a custom sort order that is not alphabetical or numeric.