sqlcmd.net validated sql reference

Tag archive

#case

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

3 commands with this tag Browse related patterns quickly
advanced aggregation MySQL MariaDB SQL Server PostgreSQL SQLite

Aggregate Rows Conditionally With CASE Inside An Aggregate

Use `CASE WHEN` inside `SUM` or `COUNT` to produce multiple metrics from a single pass over grouped data.

intermediate conditional-logic MySQL MariaDB SQL Server PostgreSQL SQLite

Return Different Values With CASE WHEN

Evaluate conditions row-by-row inside a `SELECT` to produce computed columns based on branching logic.

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.