有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")