ASELECT学号,姓名,YEAR(GETDATE())-YEAR(出生日期)年龄FROM学生WHERE年龄>24
BSELECT学号,姓名,YEAR(GETDATE())-YEAR(出生日期)年龄FROM学生WHERE YEAR(出生日期)>24
CSELECT学号,姓名,YEAR(GETDATE())-YEAR(出生日期)年龄FROM学生WHERE YEAR(GETDATE())-YEAR(出生日期)>24
DSELECT学号,姓名,年龄=YEAR(GETDATE())-YEAR(出生日期)FROM学生WHERE YEAR(GETDATE())-YEAR(出生日期)>24