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

Union in sql

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

-2

Similar codes

1 vote217 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote221 views1 answer
Datetime postgres typeorm
SQL
0 vote215 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote221 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote246 views1 answer
Stratified sampling sql
SQL
2 votes221 views1 answer
Datetrunc
SQL
8 votes227 views4 answers
Postgresql server restart
SQL
0 vote235 views1 answer
Sql sum if
SQL
1 vote211 views1 answer
Mysql column start with string
SQL
1 vote220 views1 answer
Backup mysql data only
SQL