单项选择题

Employee的表结构为：职工号、单位号、工资，与SELECT * FROM Employee WHERE 工资>=10000 AND 工资<=12000等价的SQL命令是

A．SELECT * FROM Employee WHERE 工资 BETWEEN 10000 AND 12000
B．SELECT * FROM Employee WHERE BETWEEN 10000 OR 12000
C．SELECT * FROM Employee WHERE 工资>=10000 AND <=12000
D．SELECT * FROM Employee WHERE 工资>=10000 OR <=12000

<上一题目录下一题>

热门试题

单项选择题

Employee的表结构为：职工号、单位号、工资，查询单位号为 002 的所有记录存储于临时表文件info中，正确的SQL命令是

A．SELECT * FROM Employee WHERE 单位号="002" TO DBF CURSOR info
B．SELECT * FROM Employee WHERE 单位号="002" INTO CURSOR DBF info
C．SELECT * FROM Employee WHERE 单位号="002" TO CURSOR info
D．SELECT * FROM Employee WHERE 单位号="002" INTO CURSOR info

单项选择题

Employee的表结构为：职工号、单位号、工资，查询至少有5名职工的每个单位的人数和最高工资，结果按工资降序排序。正确的SQL命令是

A．SELECT 单位号,COUNT(*),MAX(工资) FROM Employee GROUP BY 单位号; WHERE COUNT(*)>=5 ORDER BY 3 DESC
B．SELECT 单位号,COUNT(*),MAX(工资) FROM Employee ORDER BY 单位号; HAVING COUNT(*)>=5 ORDER BY 3 DESC
C．SELECT 单位号,MAX(工资) FROM Employee GROUP BY 单位号; HAVING COUNT(*)>=5 ORDER BY 3 DESC
D．SELECT 单位号,COUNT(*),MAX(工资) FROM Employee; GROUP BY 单位号 HAVING COUNT(*)>=5 ORDER BY 3 DESC