SQL语句出问题了,大家帮我看看!谢谢了.

[yp7457177]

select s_number as 学号,
s_name as 姓名,
sex as 性别,
--year(getdate())-year(birthday) as 年龄
from t_student
where year(getdate())-year(birthday)<=25 and sex='男'
我想得到25岁以下的性别为男的结果.出错了.帮看一下.

where year(getdate())-year(birthday)<=25 and sex='男'这句有问题.我怎么改呀!

[marco08]

where datediff(year, birthday, getdate())<=25 and sex='男'

[chuifengde]

where datediff(year,birthday,getdate())<=25

[akuzou]

where datediff(year,birthday,getdate())<=25 and sex='男'

[happydreamer]

select s_number as 学号,
s_name as 姓名,
sex as 性别,
datediff(year,birthday,getdate()) as 年龄
from t_student
where datediff(year,birthday,getdate())<=25

[zjcxc]

-- 如果要精度的25岁

where birthday > dateadd(year, -25, getdate()) and sex='男'

[playwarcraft]

出错了.帮看一下.
-----------------------
錯誤提示是什麼?

[yp7457177]

谢谢.

[marco08]

where (year(getdate())-year(birthday))<=25 and sex='男'
--這樣率效不高

[marco08]

--汗, 不到一分鍾就有10個回複

[yp7457177]

select s_number as 学号,
s_name as 姓名,
sex as 性别,
year(getdate())-year(birthday) as 年龄,
polity as 政治面貌
from t_student
where year(getdate())-year(birthday)<=25 and sex='男'

我这个也不错.