select iif(线长<=500,'500以内', iif(线长<=2000,'500至2000',iif(线长>2000,'大于2000',))),count(*)
from table1
where id<1000
group by iif(线长<=500,'500以内', iif(线长<=2000,'500至2000',iif(线长>2000,'大于2000',)))
select sum(case when 线长 <500 then 1 else 0 end ) as [<500],
sum(case when 500<=线长 <=2000 then 1 else 0 end ) as [500-2000],
sum(case when 线长 >2000 then 1 else 0 end ) as [>2000],
from TB
求和:
select sum(case when 线长<500 then 线长 else 0 end) as [500以内],
sum(case when 线长>=500 and 线长<=2000 then 线长 else 0 end)as[500至1000],
sum(case when 线长>2000 then 线长 else 0 end) as [大于2000]
from tb
select sum(case when 线长<500 then 1 else 0 end) as [500以内],
sum(case when 线长>=500 and 线长<=2000 then 1 else 0 end)as[500至1000],
sum(case when 线长>2000 then 1 else 0 end) as [大于2000]
from tb
select sum(iif(线长<500,1,0)) as [500以内],
sum(iif(线长>=500 and 线长<=2000,1,0))as[500至1000],
sum(iif(线长>2000,1,0)) as [大于2000]
from tb
select sum(iif(线长<500,线长,0)) as [500以内],
sum(iif(线长>=500 and 线长<=2000,线长,0))as[500至1000],
sum(iif(线长>2000,线长,0)) as [大于2000]
from tb