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

3 votes157 views1 answer
Insert into table from another table mysql
SQL
7 votes201 views2 answers
Oracle foreign key reference table
SQL
8 votes175 views4 answers
Postgresql server restart
SQL
1 vote141 views2 answers
Postgresql list columns
SQL
0 vote168 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote160 views1 answer
Except in sql alchemy
SQL
2 votes162 views1 answer
Oracle percentage
SQL
-1 vote145 views1 answer
Ssql to lowercqse
SQL
12 votes161 views1 answer
Env var for setting password for root user mysql docker hub
SQL
15 votes189 views4 answers
Mysql export database command line
SQL