单项选择题

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

单项选择题

Employee的表结构为：职工号、单位号、工资，Department 的表结构为：单位号、单位名称、人数，与下列语句等价的SQL命令是SELECT 职工号,单位名称 FROM Employee,Department ;WHERE 工资>12000 AND Employee.单位号=Department.单位号

A．SELECT 职工号, 单位名称 FROM Department JOIN INNER employee ON Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
B．SELECT 职工号, 单位名称 FROM Department INNER JOIN employee ON Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
C．SELECT 职工号, 单位名称 FROM Department JOIN INNER employee Department.单位号 = Employee.单位号 WHERE Employee.工资 > 12000
D．SELECT 职工号, 单位名称 FROM Department INNER JOIN employee ON Department.单位号 = Employee.单位号 Employee.工资 > 12000