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 vote93 views1 answer
Search In the Database using Text
SQL
1 vote116 views1 answer
Check current sequence value postgres
SQL
6 votes132 views1 answer
How to get the size of the database in postgresql
SQL
0 vote95 views1 answer
Coalesce for comma separated in sql server
SQL
15 votes103 views5 answers
If null mysql
SQL
0 vote104 views7 answers
10 random questions use python and SQL
SQL
0 vote111 views1 answer
Foreign key multiple columns
SQL
0 vote108 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote101 views1 answer
Sql: extract day text from datetime value
SQL
1 vote98 views1 answer
Oracle get current schema
SQL