单选题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 staffB SELECT DISTINCT dept FROM staffC SELECT (dept) UNIQUE FROM staffD SELECT (dept) DISTINCT FRO

题目
单选题
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


相似考题