Union All

•Number of columns must be same
•Return results from both queries, including duplicate rows

Select employee_id, job_id, department_id
From employees
UNION ALL
Select employee_id, job_id, department_id
From job_history
Order by employee_id;



The combination of two tables totals to 30 rows. The UNION ALL operator does not eliminate duplicate rows.


0 comments:

Post a Comment