试题详情
单项选择题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
  • 关注下方微信公众号,在线模考后查看

热门试题