关于人数统计,帮顶又分~~~

[soft1000_hb]

我想统计1980-01-01以后出生的人员数量,Birthday为DateTime型,语句
set @m = convert(int,'sum(case when Birthday<=convert(varchar(10),1980-01-01,120) then 1 else 0)')
一直报错,数据表为UserInfo,小弟初学SQL,望各位高手指点迷津~
谢谢~~~~

[wzy_love_sly]

帮顶

[hlq8210]

select count(1) from userinfo where Birthday>='1980-01-01'

[gahade]

select count(*) from UserInfo where Birthday>'1980-01-01'

[pt1314917]

declare @m int
select @m=count(1) from  userinfo where Birthday> ='1980-01-01' 
select @m

[soft1000_hb]

谢谢,各位高手~~~

[wzy_love_sly]

create table tb(Birthday datetime)
insert into tb select '1979-01-01'
insert into tb select '1978-01-01'
insert into tb select '1977-01-01'

declare @m int
select @m=count(1) from tb where Birthday <cast('1980-01-01' as datetime)+1
select @m

3

[wzy_love_sly]

日 掉线了
他们怎么都是>?

[pt1314917]

1980-01-01后出生的啊，疯子