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 vote108 views1 answer
Mysql multiple primary keys
SQL
2 votes98 views1 answer
Scaffold npgsql net core
SQL
27 votes108 views4 answers
Get all tables with column name sql
SQL
31 votes102 views3 answers
SQL Server change column data type
SQL
0 vote99 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote103 views1 answer
Linebreak sql
SQL
20 votes115 views5 answers
Reset auto increment mysql
SQL
0 vote105 views1 answer
Original Query
SQL
0 vote119 views2 answers
How to install psql in ubuntu
SQL
0 vote108 views1 answer
Create mysql pool connection python flask
SQL