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 vote140 views1 answer
Sql restore backup query
SQL
0 vote170 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
1 vote137 views1 answer
Error code 1055
SQL
-1 vote167 views1 answer
Partial search in sql
SQL
0 vote151 views3 answers
Drop multiple columns in sql
SQL
0 vote244 views3 answers
Insert or ignore postgres
SQL
0 vote164 views1 answer
Dual in db2
SQL
1 vote143 views3 answers
Execute sp in sql server
SQL
1 vote109 views1 answer
Mysql show attributes of a table
SQL
0 vote147 views1 answer
T-sql check if data exists
SQL