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
正确答案:B
答案解析:有
微信扫一扫手机做题