Answers for "multiple select query in sql without join to get all columns"

sql select from multiple tables without join

-- 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;

Posted by: Guest on April-22-2021

Code answers related to "multiple select query in sql without join to get all columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "multiple select query in sql without join to get all columns"

Code answers related to "multiple select query in sql without join to get all columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "multiple select query in sql without join to get all columns"

Code answers related to "multiple select query in sql without join to get all columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us