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