select htid, [50天]=sum(case when datediff(dd,starttime,getdate()) =50 then 1 else 0 end), [60天]=sum(case when datediff(dd,starttime,getdate()) =60 then 1 else 0 end), [70天]=sum(case when datediff(dd,starttime,getdate()) =70 then 1 else 0 end), [75天]=sum(case when datediff(dd,starttime,getdate()) =75 then 1 else 0 end), from test group by htid
select htid,datediff(dd,starttime,getdate()) as 'days',count(*) as 'cnt' from 表 where datediff(dd,starttime,getdate()) in(50,60,70,75) group by htid,datediff(dd,starttime,getdate())
[50天]=sum(case when datediff(dd,starttime,getdate()) =50 then 1 else 0 end),
[60天]=sum(case when datediff(dd,starttime,getdate()) =60 then 1 else 0 end),
[70天]=sum(case when datediff(dd,starttime,getdate()) =70 then 1 else 0 end),
[75天]=sum(case when datediff(dd,starttime,getdate()) =75 then 1 else 0 end),
from test group by htid
group by htid,datediff(dd,starttime,getdate())