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 vote136 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
1 vote114 views5 answers
Spring boot sql logging
SQL
0 vote166 views1 answer
Set open file limit mac catalina mysql
SQL
3 votes145 views2 answers
How to load files in mysql
SQL
0 vote142 views1 answer
How many columns can be used for creating index?
SQL
0 vote144 views1 answer
Get all employees if name ends with in sql
SQL
0 vote149 views1 answer
Mysql update even / odd rows
SQL
0 vote187 views1 answer
Delete from table where length sql
SQL
94 votes200 views4 answers
Create database postgres
SQL
0 vote140 views1 answer
Can we rollback deleted data in sql
SQL