SQL UNION Query

The SQL Union operator combines the result set of two or more SELECT statements into a single result set. The Union operator will return all the distinct records from all queries by removing the duplicate rows. The following are the basic rules for SQL Server Union operator: SQL UNION Query Syntax The syntax behind the … Read more