How to retrieve department_id column without any duplication from employee relation?
Answer options
A
SELECT DISTINCT department_id FROM employee;
B
SELECT department_id FROM employee;
C
SELECT UNIQUE department_id FROM employee;
D
SELECT TOP 1 department_id FROM employee;
Correct answer: SELECT DISTINCT department_id FROM employee;
Explanation
DISTINCT removes duplicates from the result set.