单项选择题

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

单项选择题

在表结构为（职工号，姓名，工资）的表Employee中查询职工号的第5位开始的4个字符为 0426 职工情况，正确的SQL命令是

A．SELECT * FROM Employee WHERE SUBSTR(职工号,4,5)="0426"
B．SELECT * FROM Employee WHERE STR(职工号,4,5)="0426"
C．SELECT * FROM Employee WHERE STR(职工号,5,4)="0426"
D．SELECT * FROM Employee WHERE SUBSTR(职工号,5,4)="0426"