Tags / union
Top 1 Record per Product with Ties: Using ROW_NUMBER() Function for SQL Queries
Consolidating SQL UNION with JOIN: A Deeper Dive
Using UNION with Common Table Expressions in SQL Server 2014 Developer: Workarounds and Best Practices
Working with Union Queries in MSSQL: Exporting a Table to a CSV File
Alternating Category Order While Maintaining Groupings Based on Question ID in SQL