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 vote358 views1 answer
Sql recherche nom prenom
SQL
2 votes345 views2 answers
Postgres set user as superuser
SQL
0 vote356 views1 answer
Psql select * from table
SQL
0 vote401 views1 answer
How to fetch data from database in sql
SQL
16 votes385 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote362 views1 answer
Where to locate set password for mysql
SQL
0 vote364 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote472 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote375 views1 answer
Sql change primary key to composite key
SQL
0 vote398 views1 answer
Oracle concat datetime
SQL