查询所有目前年龄在35岁以上(不含35岁)的职工信息(姓名,性别和年龄),正确的命令是()
A.
. select 姓名,性别,YEAR(GETDATE())-YEAR(出生日期)年龄 from 职工where 年龄>35
B.
. select 姓名,性别,YEAR(GETDATE())-YEAR(出生日期)年龄 from 职工where YEAR(出生日期)>35
C.
. select 姓名,性别,YEAR(GETDATE())-YEAR(出生日期)年龄 from 职工where YEAR(getdate())-YEAR(出生日期)>35
D.
select 姓名,性别,年龄=YEAR(GETDATE())-YEAR(出生日期)from 职工where where YEAR(getdate())-YEAR(出生日期)>35