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 vote127 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
7 votes123 views2 answers
3rd height salary sql
SQL
1 vote130 views1 answer
Mysql select and count left join
SQL
20 votes123 views4 answers
Reset auto increment in MySQL
SQL
0 vote115 views1 answer
Mysqlcli how to load external sql file
SQL
1 vote119 views2 answers
Extract weekday from date in sql
SQL
2 votes133 views1 answer
Mysql select true or false
SQL
3 votes128 views2 answers
Sqlite show table structure
SQL
1 vote116 views1 answer
Sql eliminare un record
SQL
6 votes119 views2 answers
Mysqldump password in file
SQL