sqlcmd.net validated sql reference

Tag archive

#lateral

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

2 commands with this tag Browse related patterns quickly
advanced reshaping MySQL MariaDB SQL Server PostgreSQL SQLite

Convert Columns to Rows With UNPIVOT

Reshape a wide table by turning multiple columns into key-value row pairs — the inverse of a PIVOT operation.

advanced joining MySQL SQL Server PostgreSQL

Reference Outer Columns Inside a Subquery With LATERAL

Use `LATERAL` (or `CROSS APPLY` on SQL Server) to let a subquery reference columns from the preceding table in the `FROM` clause.