SQL Union Clause

To combine the data from two tables into a single output, we use the UNION clause in the SELECT statement. Union gives all the records from both the queries after eliminating the duplicate records. Each SQL statement within the UNION ALL query must have the same number of fields in the result sets with similar data types.

The syntax of UNION statement is :-

Employees Mumbai :-

Employees Banglore :-

Using the UNION Command

Example:-
List all different employee names in Mumbai and Banglore :-

RESULT:-

Note: This command cannot be used to list all employees in Mumbai and Banglore. In the example above we have one employees with equal names, and only one of them is listed. The UNION command only selects distinct values.

If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.