Union in SQL Server

Union: Union will combine the result of two sql queries into a single result set. Union Specifies that multiple result sets are to be combined and returned as a single result set Syntax:

Points to remember about union operator. The number and the order of the columns must be the same in all queries. […]

Read More