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

1 vote270 views1 answer
Sql in array query
SQL
10 votes258 views3 answers
Insert into auto increment mysql
SQL
5 votes305 views2 answers
Add days in oracle sql
SQL
1 vote268 views1 answer
Oracle sql average
SQL
0 vote291 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote271 views1 answer
Sqlite show columns in table
SQL
0 vote300 views1 answer
Get statis values sql
SQL
1 vote298 views2 answers
Mysql limit offset
SQL
1 vote287 views1 answer
Check current sequence value postgres
SQL
6 votes264 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL