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

Union in sql

UNION:
COMBINES THE RESULT OF 2 QUERY AND
REMOVES DUPLICATE ROWS AND
SORTS BY FIRST COLUMN

-2

Similar codes

0 vote182 views4 answers
Mysql count table rows
SQL
6 votes268 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote298 views1 answer
Site:av.ru "files"
SQL
0 vote201 views1 answer
Default value false mysql
SQL
0 vote232 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
2 votes218 views2 answers
Install postgresql
SQL
0 vote159 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote221 views1 answer
Oracle schema size
SQL
2 votes190 views1 answer
Cast string to datetime mysql
SQL
1 vote183 views1 answer
Psql datetime grather than
SQL