What is union in sql

Sql union

-- UNION: distinct values (slower)
SELECT emp_name AS name from employees
UNION       
SELECT cust_name AS name from customers;

-- UNION ALL: keeps duplicates (faster)
SELECT emp_name AS name from employees
UNION ALL      
SELECT cust_name AS name from customers;

Union SQL

SQL> SELECT  ID, NAME, AMOUNT, DATE
   FROM CUSTOMERS
   LEFT JOIN ORDERS
   ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID
UNION
   SELECT  ID, NAME, AMOUNT, DATE
   FROM CUSTOMERS
   RIGHT JOIN ORDERS
   ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;

Source: tutorialspoint.com

What is union in sql

UNION:
COMBINES THE RESULT OF 2 QUERY AND
REMOVES DUPLICATE ROWS AND
SORTS BY FIRST COLUMN

-2

Similar codes

0 vote342 views1 answer
Oracle plsql sleep
SQL
0 vote320 views1 answer
Query to insert image
SQL
0 vote334 views1 answer
With_for_update sqlalchemy
SQL
1 vote313 views1 answer
Oracle explain plan
SQL
11 votes351 views6 answers
Mysql else if
SQL
-1 vote400 views5 answers
Left join sql
SQL
3 votes355 views3 answers
Mysql declare variable
SQL
0 vote375 views1 answer
Find and replace query in wordpress\
SQL
0 vote316 views1 answer
How to avoid duplicate records in sqlite
SQL
2 votes693 views1 answer
Oracle virtual column
SQL