Question: What does the following SQL query do ? SELECT employee _ id FROM employees UNION SELECT employee _ id FROM former _ employees; Retrieves all
What does the following SQL query do
SELECT employeeid FROM employees UNION
SELECT employeeid FROM formeremployees;
Retrieves all employee IDs from both 'employees' and 'formeremployees' tables, removing duplicates.
Retrieves all employee IDs from the 'employees' table.
Retrieves employee IDs from both 'employees' and 'formeremployees' tables, removing duplicates.
Retrieves employee IDs from both 'employees' and 'formeremployees' tables, including duplicates.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
