单选题
VF
题号 #146535
查询每个部门年龄最长者的信息,要求得到的信息包括部门名和最长者的出生日期。 正确的命令是
参考答案
A
答案解析
暂无解析
你可能感兴趣的试题
A.SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)ASC
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)ASC
B.SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)DESC
FROM 部门,职工 WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY COUNT(职工号)DESC
C.SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 ASC
FROM 部门,职工WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 ASC
D.SELECT 部门名,COUNT(职工号)AS 职工人数;
FROM 部门,职工WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 DESC
FROM 部门,职工WHERE 部门.部门号=职工.部门号;
GROUP BY 部门名 HAVING COUNT(*)>=10;
ORDER BY 职工人数 DESC
A.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工;
WHERE 年龄>35
WHERE 年龄>35
B.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工;
WHERE YEAR(出生日期)>35
WHERE YEAR(出生日期)>35
C.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工;
WHERE YEAR(DATE())-YEAR(出生日期)>35
WHERE YEAR(DATE())-YEAR(出生日期)>35
D.SELECT 姓名,性别,年龄=YEAR(DATE())-YEAR(出生日期)FROM 职工;
WHERE YEAR(DATE())-YEAR(出生日期)>35
WHERE YEAR(DATE())-YEAR(出生日期)>35
A.MODIFY TABLE 工资 ADD COLUMN 实发工资 N(9,2)
B.MODIFY TABLE 工资 ADD FIELD 实发工资 N(9,2)
C.ALTER TABLE 工资 ADD COLUMN 实发工资 N(9,2)
D.ALTER TABLE 工资 ADD FIELD 实发工资 N(9,2)