有SQL语句:
SELECTDISTINCT系号FROM教师WHERE工资>=;
ALL(SELECT工资FROM教师WHERE系号="02")
与如上语句等价的SQL语句是()。
A.SELECTDISTINCT系号FROM教师WHERE工资>=;
(SELECTMAX(工资)FROM教师WHERE系号="02")
B.SELECTDISTINCT系号FROM教师WHERE工资>=;
(SELECTMIN(工资)FROM教师WHERE系号="02")
C.ELECTDISTINCT系号FROM教师WHERE工资>=;
ANY(SELECT工资FROM教师WHERE系号="02")
D.SELECTDISTINCT系号FROM教师WHERE工资>=;
SOME(SELECT工资FROM教师WHERE系号="02")