问题
选择题
How long ______ teaching? Forty years.
A.he will have been
B.will have he been
C.will have been he
D.will he have been
答案
答案:D
How long ______ teaching? Forty years.
A.he will have been
B.will have he been
C.will have been he
D.will he have been
答案:D
(33)~(34)使用如下三个表: 部门.dbf:部门号C(8),部门名C(12),负责人C(6) 职工.dbf:部门号C(8),职工号C(10),姓名C(8),性别C(2),出生日期D(8) 工资.dbf:职工号C(10),基本工资N(8.2),津贴N(8.2),奖金N(8.2) |
查询每个部门年龄最小者的信息,要求得到的信息包括部门名和最长者的出生日期。正确的命令是( )。
A.SELECT部门名,MIN(出生日期)FROM部门JOIN职工; WHERE部门.部门号=职工.部门号GROUP BY部门名
B.SELECT部门名,MIN(出生日期)FROM部门JOIN职工; ON部门.部门号=职工.部门号GROUP BY部门名
C.SELECT部门名,MAX(出生日期)FROM部门JOIN职工; ON部门.部门号=职工.部门号GROUP BY部门名
D.SELECT部门名,MAX(出生日期)FROM部门JOIN职工;