选项
A.
SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期) as 年龄 FROM 职工 WHERE 年龄>35
B.
SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期) as 年龄 FROM 职工 WHERE YEAR(出生日期)>35
C.
SELECT 姓名,性别,年龄=YEAR(DATE())-YEAR(出生日期) FROM 职工 WHERE YEAR(DATE())-YEAR(出生日期)>35
D.
SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期) as 年龄 FROM 职工 WHERE YEAR(DATE())-YEAR(出生日期) >35
正确答案:D