What is 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

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 vote309 views1 answer
Plpgsql create function
SQL
2 votes251 views2 answers
Mamp connect mysql terminal
SQL
0 vote265 views1 answer
Mysql equivalent decode oracle
SQL
3 votes283 views1 answer
Laravel paginate raw sql
SQL
0 vote273 views1 answer
Wordpress database query change url
SQL
0 vote247 views4 answers
Mysql replace regex
SQL
0 vote257 views1 answer
Jenkins SQLCMD run
SQL
1 vote258 views1 answer
Mysql tables max count
SQL
-1 vote265 views1 answer
Extract Data from SQL Server into XML Format
SQL
3 votes271 views3 answers
Mysql declare variable
SQL