- 首页 > 资讯 > SQL Server > 正文
SQL按家庭维度统计信号强度
先分组再分段统计每段个数
####按家庭维度统计信号强度
create table Power_STAT
(select
DeviceId,
count(DeviceId) as AllNum,
sum(case when SubdeviceWlanRadioPower >= -67 then 1 else 0 end) as GoodNum,
sum(case when SubdeviceWlanRadioPower <= -68 and SubdeviceWlanRadioPower >= -70 then 1 else 0 end ) as NormalNum,
sum(case when SubdeviceWlanRadioPower <= -71 then 1 else 0 end) as PoorNum
from wide_table_all_row
where SubdeviceWlanRadioPower!= ''
group by DeviceId);
相关文章
图文推荐
- 文章
- 推荐
- 热门新闻