select
convert(char(10),时间,120) 日期,
[0开头的次数]=sum(case left(号码,1)='0' then 1 else 0 end),
[1开头的次数]=sum(case left(号码,1)='1' then 1 else 0 end),
[总次数]=count(*)
from
表
group by
convert(char(10),时间,120)
convert(char(10),时间,120) 日期,
[0开头的次数]=sum(case left(号码,1)='0' then 1 else 0 end),
[1开头的次数]=sum(case left(号码,1)='1' then 1 else 0 end),
[总次数]=count(*)
from
表
group by
convert(char(10),时间,120)
convert(char(10),时间,120) as 日期,
[0开头的次数]=sum(case when left(号码,1)='0' then 1 else 0 end),
[1开头的次数]=sum(case when left(号码,1)='1' then 1 else 0 end),
[总次数]=count(*)
from
表
group by
convert(char(10),时间,120)