分段查询统计_JAVA_编程开发_程序员俱乐部

select 
sum(case when (landarea>0 and landarea<4000) then 1 else 0 end)  s1,
sum(case when  landarea>=4000 and landarea<8000  then 1 else 0 end) s2,
sum(case when landarea>=8000  then 1 else 0 end) s3 ,
count(*) as total
from mp_p_majorprojects