Prepare for your SQL interview with the question: "Combining Results with UNION" (Data Analyst level).

Solve the "Combining Results with UNION" SQL interview question on SQLSimplified. Access the live database playground in your browser to write and run queries, see hints, and inspect correct query solutions.

Data AnalystQuestion 56 of 57

Combining Results with UNION

Problem

Return a single column named id containing all employee_ids from the employees table AND all department_ids from the departments table. Remove duplicates.

Combining Results with UNION

Problem

Try It

Hint

Solution

Problem

Try It

Hint

Show hint

Solution

Show solution