A.1
B.2
C.3
D.4
[单选题]有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"
[单选题]有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 DISTINC
[单选题]有SQL语句: SELECT DISTINCT系号FROM教师WHERE工资>= ; ALL(SELECT 工资 FROM 教师 WHERE 系号=“02”) 该语句的执行结果是系号A.“01”和“02”B.“01” 和“03”C.“01”和“04”D.“02”和“03”
[单选题]有SQL语句SELECT DISTINCT系号FROM教师WHERE工资><=ALL (SELECT工资FROM教师WHERE系号=/"02/")该语句的执行结果是系号A."01"和"02"B."01"和"03"C."01"和"04"D."02"和"03"
[单选题]有如下SQL语句:SELECT SUM(工资) FROM 职工表 WHERE 仓库号 IN;(SELECT 仓库号 FROM 仓库表 WHERE 所在城市="北京" OR 所在城市="上海")执行语句后,工资总和是A.3500.00B.3000.00C.5000.00D.10500.00
[单选题]若有如下SQL语句: SELECT班级号,姓名,工资; FROM教师; ORDER BY班级号,工资DESC 执行该语句后,查询结果第一条记录的“职工号”是( )。A.T11B.T33C.T55D.T66
[单选题]有如下SQL语句: SELECT DISTINCT仓库号FROM职工表WHERE工资>=ALL (SELECT工资FROM职工表WHERE仓库号="A1") 执行语句后,显示查询到的仓库号有______。A.A1B.A3C.A1,A2D.A1,A3
[单选题]有SQL语句:SELECT * FROM教师WHERE NOT(工资>3000 OR 工资<2000)与如上语句等价的SQL语句是A.SELECT*FROM 教师 HWERE 工资 BETWEEN 2000 AND 3000B.SELECT*FROM 教师 HWERE 工资 >2000 AND 工资<3000C.SELECT*FROM 教师 HWERE 工资>2000 OR 工资<3000D.SELECT*FROM 教师 HWERE 工资<=2000 A
[单选题]有SQL语句 SELECT * FROM 教师 WHERE NOT(工资>30000R工资<2000) 与如上语句等价的SQL语句是A.SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B.SELECT * FROM 教师 WHERE 工资>2000 AND工资<3000C.SELECT * FROM 教师 WHERE 工资>2000 OR工资<3000D.SELECT * FROM 教师 WHERE 工资<=2000 AND工资>=3000
[单选题]有SQL语句:SELECT * FROM 教师 WHERE NOT(工资>3000 OR 工资<2000)与如下语句等价的SQL语句是A)SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000C)SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000D) SELECT*FROM 教师 WHERE 工资<=200