有SQL语句：SELECT * FROM 教师 WHERE NOT（工资＞3000 OR 工资＜2000)与如下语句等价的SQ

A.SELECT*FROM教师WHERE工资BETWEEN2000AND3000

B.SELECT*FROM教师WHERE工资>2000AND工资<3000

C.SELECT*FROM教师WHERE工资>2000OR工资<3000

D.SELECT*FROM教师WHERE工资<=2000AND工资>=3000

A.SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000

B.SELECT * FROM 教师 WHERE 工资＞2000 AND工资＜3000

C.SELECT * FROM 教师 WHERE 工资＞2000 OR工资＜3000

D.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"

A.SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000

B.SELECT*FROM 教师 WHERE 工资＞2000 AND工资＜3000

C.SELECT*FROM 教师 WHERE 工资＞2000 OR工资＜3000

D.SELECT*FROM 教师 WHERE 工资＜=2000 AND工资＞3000

A.SELECT * from v_fstu;

B.SELECT * from view v_fstu;

C.SELECT * from view where v_fstu;

D.SELECT * where view=v_fstu;

有SQL语句： SELECT * FROM 教师 WHERE NOT (工资＞3000 OR 工资＜2000) 与如上语句等价的SQL语句是

A．SELECT*FROM 教师 WHERE 工资BETWEEN 2000 AND 3000

B．SELECT*FROM 教师 WHERE 工资＞2000 AND 工资＜3000

C．SELECT*FROM 教师 WHERE 工资＞2000 OR 工资＜3000

D．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”

A.SELECT * from v_fstu;

B.SELECT * from view v_fstu;

C.SELECT * from view where v_fstu;

D.SELECT * where view=v_fstu;

有SQL语句：SELECT 主讲课程，COUNT(*)FROM 教师 GROUP BY 主讲课程该语句执行结果含有的记录个数是A）3 B）4 C）5 D）6