sqlcmd.net validated sql reference

Tag archive

#expressions

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

2 commands with this tag Browse related patterns quickly
beginner selecting MySQL MariaDB SQL Server PostgreSQL SQLite

Select Computed Columns With Expressions

Include arithmetic, string, or conditional expressions directly in a `SELECT` list and give them an alias with `AS`.

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.