select
[~20] =sum(case when old < 20 then 1 else 0 end),
[20~30]=sum(case when old between 20 and 30 then 1 else 0 end),
[30~40]=sum(case when old between 30 and 40 then 1 else 0 end),
[40~]=sum(case when old > 40 then 1 else 0 end)
from (select old = datediff(yy,birthday,getdate()) from tb2) a
Sql server 计算各年龄段人数
最新推荐文章于 2022-05-27 21:10:48 发布