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

0 vote135 views1 answer
Difference between varchar and varchar2
SQL
1 vote150 views2 answers
Procedure syntax
SQL
0 vote168 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote139 views1 answer
Qt qsql check if table exist
SQL
0 vote132 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote125 views1 answer
Inser into example
SQL
0 vote158 views1 answer
Sql remove non numeric characters
SQL
0 vote150 views1 answer
Difference between 2 query results sql server
SQL
5 votes139 views1 answer
Oracle sysdate
SQL
0 vote136 views1 answer
Mysql export and import
SQL