SQL UNION Operator – Unification of Sets with Example
UNION operator makes it possible to connect 2 results of query and remove all existing duplicities in them. In other words, operator actually performs DISTINCT in final unification of records. Syntax SELECT Column FROM dbo.Table WHERE Condition UNION SELECT Column FROM dbo.Table WHERE Condition; Syntax is same as in all Set operators. Result… Read More »