Using UNION Operator
| Previous | Home | Next |
SQL server provide a unique operator known as the UNION operator that is used to combine the result set of two or more queries.
SELECT column_list [ INTO new_table_name]
[FROM clause]
[WHERE clause]
[GROUP BY clause]
[HAVING clause]..]
UNION [ALL]
SELECT column_list
[FROM clause]
[WHERE clause]
[GROUP BY clause]
[HAVING clause]..]
[ORDER BY clause]
[COMPUTE BY clause]
UNION ALL is the operator used to combine two or more queries with duplicate rows from different queries.
Example:
SELECT au_fname,city,state FROM authors WHERE state='UT' UNION SELECT pub_name,city,state FROM publishers
output
| Previous | Home | Next |