Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()
- ASELECT UNIQUE dept FROM staff
- BSELECT DISTINCT dept FROM staff
- CSELECT (dept) UNIQUE FROM staff
- DSELECT (dept) DISTINCT FROM staff