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 vote151 views1 answer
What is mysql_pconnect
SQL
3 votes140 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote126 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote146 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote145 views1 answer
Mysql view curren querys
SQL
1 vote157 views1 answer
Varchar plsql
SQL
7 votes151 views1 answer
Sql pagination oracle
SQL
0 vote148 views1 answer
ACCEPT nome PROMPT on oracle
SQL
26 votes139 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote139 views1 answer
Change schema of all tables postgres
SQL