Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT
column in the STAFF table?
A.
SELECT UNIQUE dept FROM staff
B.
SELECT DISTINCT dept FROM staff
C.
SELECT (dept) UNIQUE FROM staff
D.
SELECT (dept) DISTINCT FROM staff