有SQL语句:SELECT DISTINCT系号FROM教师WHERE 工资>=ALL (SELECT 工资FROM教师WHERE系号=02) 与如上语句等价的SQL语句是()
ASELECT DISTINCT系号FROM教师WHERE工资>=(SELECT MAX(工资)FROM教师WHERE 系号="02")
BSELECT DISTINCT系号FROM教师WHERE工资>=(SELECT MIN(工资)FROM教师WHERE 系号="02")
CSELECT DISTINCT系号FROM教师WHERE工资>=(ANY(SELECT(工资)FROM教师WHERE 系号="02")
DSELECT DISTINCT系号FROM教师WHERE工资>=(SOME (SELECT(工资)FROM教师WHERE 系号="02")
相关试题
-
有SQL语句:SELECT DISTINCT系号FROM教师WHERE 工资>=ALL (SELECT 工资FROM教师WHERE系号=02) 与如上语句等价的SQL语句是()
-
将该查询转换为等价的SQL语句如下:SELECT DISTINCT A1,A4 FROM R,S WHERE R.A2
-
SQL Server中,select top (1) * from stuInfo where stNo not in(select top (2) stNo from stuInfo) 以上语句的
-
SELECT * FROM comments WHERE cmtAuthor = ‘ ’;该语句作用是什么?
-
SQL 语句: SELECT * FROM USER_TABLES; 将得到什么结果: