A . 01053090A#Hm3?
B . 01003090A01
C . 01053090D09
D . 0101A01
[单选题]有如下SQL SELECT语句 SELECT *FROM stock WHERE 单价 BETWEEN 12.76 AND 15.20 与该语句等价的是A.SELECT *FROM stock WHERE 单价<=15.20 .AND. 单价>=12.76B.SELECT *FROM stock WHERE 单价<15.20 .AND. 单价>12.76C.SELECT *FROM stock WHERE 单价>=15.20 .AND. 单价<=12.76D.SELECT *FROM stock
[单选题]有如下SQL-SELECT语句SELECT * FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4与该语句等价的是A.SELECT * FROM HH WHERE 单价<=13.4 AND 单价>=10.6B.SELECT * FROM HH WHERE 单价<13.4 AND 单价>10.6C.SELECT * FROM HH WHERE 单价>=13.4 AND 单价<=10.6D.SELECT * FROM HH WHERE 单
[单选题]有如下SQL-SELECT语句 SELECT*FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4 与该语句等价的是A.SELECT*FROM HH WHERE 单价 <=13.4 AND 单价 >=10.6B.SELECT*FROM HH WHERE 单价 <13.4 AND 单价 >10.6C.SELECT*FROM HH WHERE 单价 >=13.4 AND 单价 <=10.6D.SELECT*FROM HH WHERE 单价 >13.4 AND 单价 <10.6
[单选题](21 )执行 SQL 语句: SELECT sno,grsde FROM SC WHERE cno= ' c1 ' AND grade<60 ,则该语句对关系 S C执行的操作有A. )交( ∩ )和选择( σ )B. )选择( σ )和投影( ∏ )C. )并( ∪ )和投影( ∏ )D.) 选择( σ )和笛卡尔积( × )
[单选题]SQL语句:SELECT*FROM班级WHERE班级号NOT IN;(SELECT班级号FROM学生)该语句等价于:SELECT*FROM班级WHERE NOT______;(SELECT*FROM学生WHERE班级号=班级.班级号)
[单选题]有下列SQL SELECT语句:SELECT*FROM 工资表 WHERE 基本工资=1000下列与该语有下列SQL SELECT语句: SELECT*FROM 工资表 WHERE 基本工资<=3000 AND 基本工资>=1000 下列与该语句等价的是( )。A.SELECT*FROM 工资表 WHERE 基本工资 BETWEEN 1000 AND 3000B.SELECT*FROM 工资表 WHERE 基本工资 BETWEEN 3000 AND 1000C.SELECT*FROM 工资表 W
[单选题]有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 DISTINCT 系号 FROM 教师 WHERE 工资>=; ALL(SELECT 工资 FROM 教师 WHERE 系号="02") 该语句的执行结果是系号A) "01"和"02" B)"01"和"03" C)"01"和"04" D)"02"和"03"
[单选题]有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