Union 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

1 vote183 views1 answer
Error code 1175 mysql fix
SQL
18 votes186 views3 answers
Mysql add column with default value
SQL
2 votes226 views1 answer
Oracle log files
SQL
2 votes218 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
6 votes293 views2 answers
Non relational database
SQL
0 vote208 views2 answers
Compound operator in sql
SQL
0 vote229 views1 answer
Stop psql server windows
SQL
4 votes197 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote230 views1 answer
Postgres power
SQL
5 votes217 views1 answer
Oracle generate list of dates in between a date range
SQL