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

3 votes530 views6 answers
Sql unique select
SQL
10 votes315 views1 answer
How to import database in mysql by cmd
SQL
0 vote352 views1 answer
How to update date value in sql
SQL
40 votes382 views6 answers
Update table mysql
SQL
0 vote343 views1 answer
Declarative base sqlalchemy
SQL
0 vote328 views1 answer
Bash block size ls /var/lib/mysql
SQL
16 votes346 views2 answers
Sql exists
SQL
2 votes338 views1 answer
Mysql how to store lat,lng
SQL
1 vote328 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote316 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL