题目2单选题
数据库中有"teacher"表,表的部分字段如下 teacher表: 序号 字段名 备注 1 xnum 系号 2 salary 工资 SQL语句:SELECT DISTINCT xnum FROM teacher WHERE salary >=ALL (SELECT salary FROM teacher WHERE xnum ="02")与如上语句等价的SQL语句是______.( )A. SELECT DISTINCT xnum FROM teacher WHERE salary >=(SELECT MIN(salary) FROM teacher WHERE xnum ="02")B. SELECT DISTINCT xnum FROM teacher WHERE salary >=ANY(SELECT salary FROM teacher WHERE xnum ="02")C. SELECT DISTINCT xnum FROM teacher WHERE salary >= (SELECT MAX(salary) FROM teacher WHERE xnum ="02")D. SELECT DISTINCT xnum FROM teacher WHERE salary >=SOME (SELECT salary FROM teacher WHERE xnum ="02")