Union 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

3 votes215 views2 answers
Laravel tosql with bindings
SQL
0 vote201 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote202 views1 answer
Install mysql for fedora 34
SQL
0 vote200 views1 answer
C# check if mysql query modified rows
SQL
1 vote236 views1 answer
T-sql disable system versioning
SQL
0 vote271 views3 answers
Mysql keyword search
SQL
16 votes206 views3 answers
Tsql rename column name
SQL
0 vote218 views1 answer
Make parameters nullable in sql server
SQL
0 vote234 views1 answer
Sql values not in another table
SQL
0 vote223 views1 answer
Excel vba import data to sql server
SQL