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

2 votes329 views1 answer
Oracle trace session
SQL
0 vote337 views1 answer
Mysql find missing values
SQL
1 vote328 views1 answer
Error code 1055
SQL
0 vote323 views1 answer
Truncate table sql server foreign key
SQL
2 votes367 views1 answer
How to find table table in stored procedure sql server
SQL
5 votes377 views4 answers
Mysql update column with value from another table
SQL
0 vote344 views1 answer
Sql pad left 0
SQL
0 vote342 views1 answer
Create a table from one field of another table
SQL
5 votes399 views1 answer
Oracle drop index if exists
SQL
1 vote350 views1 answer
Postgres set sequence value to max id
SQL