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 vote226 views1 answer
Tsql create unique index composite
SQL
0 vote255 views1 answer
Postgresql like
SQL
13 votes237 views3 answers
Insert mysql ifile nto database
SQL
0 vote219 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
8 votes220 views4 answers
Mysql update one table from another table multiple columns
SQL
2 votes243 views1 answer
Mysql increment value by 1 in update
SQL
6 votes250 views4 answers
Mysql get random row
SQL
10 votes213 views3 answers
Sql limit results
SQL
3 votes223 views3 answers
Sql current year
SQL
0 vote231 views1 answer
Query to remove duplicate rows from a table
SQL