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

4 votes149 views1 answer
W3schools create table
SQL
2 votes152 views2 answers
Change mysql password from command line
SQL
0 vote123 views1 answer
Mariadb set vertical output format
SQL
21 votes137 views3 answers
Sql average
SQL
3 votes128 views1 answer
Oracle nextval
SQL
1 vote137 views1 answer
Crontab every month
SQL
3 votes142 views1 answer
Sql print all names that start with a given letter
SQL
4 votes145 views1 answer
Wilayah indonesia sql
SQL
5 votes132 views1 answer
List foreign key oracle
SQL
0 vote151 views1 answer
How to update date value in sql
SQL