sqlcmd.net validated sql reference

Tag archive

#union-all

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

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

Choose UNION Or UNION ALL Intentionally

`UNION` removes duplicates, while `UNION ALL` keeps them. Picking the wrong one silently changes row counts.

intermediate set-operations MySQL MariaDB SQL Server PostgreSQL SQLite

Combine Results With UNION ALL

Append result sets together without removing duplicates.