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 vote305 views3 answers
Union in sql
SQL
2 votes285 views1 answer
Oracle create directory
SQL
3 votes283 views1 answer
How to remove characters from string in mysql
SQL
0 vote301 views1 answer
Create tables from xsd to sql server database c#
SQL
-2 votes283 views3 answers
Sqlite reset autoincrement
SQL
2 votes342 views1 answer
Install postgresql centos 5
SQL
4 votes291 views3 answers
Sqlite show columns
SQL
0 vote322 views2 answers
Temp Space
SQL
0 vote297 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote293 views1 answer
Postgresql heritage
SQL