刚刚写的最长的sql
lsxaa 2008-01-16 06:39:28 select
sum( case when t_v_c+ v_c+ r_s+ g>0 and t_v_c+ v_c+ r_s+ g<100 then 1 else 0 end) as `0-100`,
sum( case when t_v_c+ v_c+ r_s+ g>100 and t_v_c+ v_c+ r_s+ g<200 then 1 else 0 end) as `100-200`,
sum( case when t_v_c+ v_c+ r_s+ g>200 and t_v_c+ v_c+ r_s+ g<300 then 1 else 0 end) as `200-300`,
sum( case when t_v_c+ v_c+ r_s+ g>300 and t_v_c+ v_c+ r_s+ g<400 then 1 else 0 end) as `300-400`,
sum( case when t_v_c+ v_c+ r_s+ g>400 and t_v_c+ v_c+ r_s+ g<500 then 1 else 0 end) as `400-500`,
sum( case when t_v_c+ v_c+ r_s+ g>500 and t_v_c+ v_c+ r_s+ g<600 then 1 else 0 end) as `500-600`,
sum( case when t_v_c+ v_c+ r_s+ g>600 and t_v_c+ v_c+ r_s+ g<700 then 1 else 0 end) as `600-700`,
sum( case when t_v_c+ v_c+ r_s+ g>700 and t_v_c+ v_c+ r_s+ g<800 then 1 else 0 end) as `700-800`,
sum( case when t_v_c+ v_c+ r_s+ g>800 and t_v_c+ v_c+ r_s+ g<900 then 1 else 0 end) as `800-900`,