Union in 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

Union in sql

UNION:
COMBINES THE RESULT OF 2 QUERY AND
REMOVES DUPLICATE ROWS AND
SORTS BY FIRST COLUMN

-2

Similar codes

0 vote336 views1 answer
Price-colour
SQL
6 votes362 views2 answers
Mysql timestamp to date
SQL
0 vote340 views1 answer
Insert thai language sql server
SQL
12 votes374 views4 answers
How to check mysql version ubuntu
SQL
1 vote360 views3 answers
Mysql parse int
SQL
0 vote382 views1 answer
Gcloud sql list databases
SQL
0 vote338 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote374 views2 answers
Oracle chain rules
SQL
0 vote365 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
5 votes357 views1 answer
Mysql count newlines in field
SQL