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 vote170 views1 answer
Postgres check for foreign key
SQL
8 votes163 views1 answer
Oracle add month
SQL
0 vote178 views1 answer
Get last date join sql
SQL
0 vote172 views1 answer
Split string by comma in sql server
SQL
0 vote246 views1 answer
Connect google bigquery connect using sqirrel
SQL
18 votes139 views2 answers
How to get all the tables displayed in oracle
SQL
18 votes171 views2 answers
Sql inner join
SQL
0 vote175 views1 answer
How to use query in nosql
SQL
0 vote187 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote277 views1 answer
Jpa generationtype sequence mysql
SQL