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

0 vote195 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote159 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote189 views1 answer
Sql decimal to 2 places
SQL
0 vote164 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote153 views1 answer
Sql create table with datetime automatically
SQL
0 vote145 views2 answers
Mysql disable foreign key checks
SQL
0 vote191 views1 answer
Mysql relationships between tables
SQL
0 vote176 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
4 votes199 views1 answer
Postgresql change default value
SQL
3 votes204 views1 answer
Oracle function
SQL