sqlcmd.net validated sql reference

Tag archive

#order-by

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

5 commands with this tag Browse related patterns quickly
intermediate selecting MySQL MariaDB SQL Server PostgreSQL SQLite

Select Random Rows

Return a random sample by ordering rows with the engine's random function and applying a row limit.

beginner ordering MySQL MariaDB SQL Server PostgreSQL SQLite

Sort By Multiple Columns

Use more than one sort key so ties are broken deterministically.

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.

beginner ordering MySQL MariaDB SQL Server PostgreSQL SQLite

Sort Rows With ORDER BY

Control the order of result rows explicitly instead of relying on storage order.

beginner pagination MySQL MariaDB SQL Server PostgreSQL SQLite

Use LIMIT Or TOP With ORDER BY For Stable Results

A row limit without an explicit sort can return different rows over time or across engines.