摘要： Select 0, CASE WHEN BLA05 between 0 and 50 THEN '0~50' WHEN BLA05 between 50 and 100 THEN '50~100' END F1, Count(distinct p.Xzqh+p.jgdm+BLA01+cast(BLA02 as varchar(50))) F2, sum(case when isnull(a,'')<>'' then 1 else 0 end) F3 From Ks k Where p.a=1 Group by (CAS 阅读全文