DATABASE & SQL/PLSQL

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

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: