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 vote175 views1 answer
Cross apply top for each row t1
SQL
12 votes176 views4 answers
How to take database dump in postgresql
SQL
0 vote210 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote188 views1 answer
How to add more columns to a table in mysql
SQL
0 vote130 views1 answer
Bigquery information_schema schema all columns
SQL
3 votes177 views2 answers
Mysql time
SQL
0 vote194 views1 answer
How to check which table has data in mysql
SQL
1 vote211 views1 answer
Sql server loop over query
SQL
22 votes185 views3 answers
How to join three tables in sql using joins
SQL
12 votes173 views2 answers
Delete all nodes neo4j
SQL