SQL UNION Operator to Concatenate Query Result

Author: Al-mamun Sarkar Date: 2020-04-15 18:27:51

SQL UNION Operator to Concatenate Query Result. The following SQL command shows how to use SQL UNION Operator to concatenate result of two different Query. 

 

SQL UNION Syntax:

SELECT column FROM table_name
UNION
SELECT column FROM table_name;

Example:

SELECT name FROM customers
UNION
SELECT name FROM employees;

 

UNION ALL Syntax:

SELECT column FROM table_name
UNION ALL
SELECT column FROM table_name;

 

Example:

SELECT name FROM customers
UNION ALL
SELECT name FROM employees;

 

<- Previous Next ->