"职工"表中有3个字段:职工编号、姓名、性别、生日。要查询男职工中年龄最大的记录,并显示该最大年龄,正确的SQL命令是( )。
A.SELECT Max(Year(Date())-Year(生日)) AS 年龄 FROM 职工WHERE 性别=男;
B.SELECT Max(Year(Date())-Year([生日])) AS 年龄 FROM 职工WHERE [性别]="男"; C.SELECT 年龄 FROM 职工 WHERE Max(Year(Date())-Year(生日)) AND 性别=男; D.SELECT 年龄 FROM 职工 WHERE Max(Year(Date())-Year([生日])) AND [性别]="男";