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
Quick AnswerThe correct answer is SELECT DISTINCT department_id FROM employee; because it directly addresses the core logic of Database Management.
DISTINCT removes duplicates from the result set.