单项选择题

有SQL语句:
SELECT DISTINCT系号FROM教师WHERE工资>=;

ALL(SELECT工资FROM教师WHERE系号=“02”)
与如上语句等价的SQL语句是
A) SELECT DISTINCT系号FROM教师WHERE工资>=;
(SELECT MAX(工资)FROM教师WHERE系号=“02”)
B) SELECT DISTINCT系号FROM教师WHERE工资>=;
(SELECT MIN(工资)FROM教师WHERE系号=“02”)
C) SELECT DISTINCT系号FROM教师WHERE工资>=;
ANY(SELECT工资FROM教师WHERE系号=“02”)
D) SELECT DISTINCT系号FROM教师WHERE工资>=;
SOME(SELECT工资FROM教师WHERE系号=“02”)
热门 试题