select [datetime] [time],
COUNT(id) [count(id)],
SUM(CAST([check] AS INT)) [COUNT(check=1)],
SUM(CAST(~[check] AS INT)) [COUNT(check=0)]
FROM tb
GROUP BY [datetime]未测试可能有手误
COUNT(id) [count(id)],
SUM(CAST([check] AS INT)) [COUNT(check=1)],
SUM(CAST(~[check] AS INT)) [COUNT(check=0)]
FROM tb
GROUP BY [datetime]未测试可能有手误
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货