雜記

SELECT sum(case when DatePart(yyyy,getdate())-年 between 0 and 10 then 1 else 0 end) as '1-10', sum(case when DatePart(yyyy,getdate())-年 between 11 and 20 then 1 else 0 end) as '11-20', sum(case when DatePart(yyyy,getdate())-年 between 21 and 30 then 1 else 0 end) as '21-30', sum(case when DatePart(yyyy,getdate())-年 between 31 and 40 then 1 else 0 end) as '31-40', sum(case when DatePart(yyyy,getdate())-年 between 41 and 50 then 1 else 0 end) as '41-50', sum(case when DatePart(yyyy,getdate())-年 between 51 and 60 then 1 else 0 end) as '51-60', sum(case when DatePart(yyyy,getdate())-年 between 61 and 70 then 1 else 0 end) as '61-70', sum(case when DatePart(yyyy,getdate())-年 between 71 and 80 then 1 else 0 end) as '71-80', sum(case when DatePart(yyyy,getdate())-年 between 81 and 130 then 1 else 0 end) as '80-' FROM 表