SELECT COUNT(distinct IIF(id=1,pol1,.NULL.)) FROM ART

SELECT COUNT(distinct case when id=1 then pol1 end) FROM ART

select count(distinct pol1) from ART where id=1

select usl.glpu, usl.mcod, usl.code_md, ;
sum(IIF(idump=3 and t_type=1, 1 ,IIF(idump=6, usl.kol_usl,IIF(idump=5 and t_type=91, usl.kol_usl*usl.tarif*0.76 ,0)))) as profpos, ;
sum(IIF(idump=3 and t_type=2, 1 ,0)) as detprof, ;
sum(IIF(idump=3 and t_type=3, 1 ,0)) as dddet, ;
sum(IIF(idump=3 and t_type=4, 1 ,0)) as ddvzr1, ;
COUNT(distinct IIF(id=44,idstrax,.NULL.)) as ddvzr44, ; && ПРОБЛЕМЫ В ЭТОЙ СТРОКЕ
sum(IIF(idump=3 and t_type=5, 1 ,0)) as detpred, ;
sum(IIF(idump=3 and t_type=6, 1 ,0)) as czpos, ;
sum(IIF(idump=3 and t_type=7, 1 ,0)) as ddvzr2, ;
sum(IIF(idump=3 and t_type=8, 1 ,0)) as profvzr, ;
sum(IIF(idump=3 and t_type=9, 1 ,IIF(idump=5 and t_type!=91, usl.kol_usl*usl.tarif/5.6 ,0))) as obrpol, ;
sum(IIF(idump=3 and t_type=10, 1 ,0)) as detperiod, ;
sum(IIF(idump=3 and t_type=19, 1 ,0)) as dompos, ;
sum(IIF(idump=3 and INLIST(t_type,16,22), 1 ,0)) as neotl, ;
sum(IIF(idump=3 and t_type=33, 1 ,0)) as dddetu, ;
sum(IIF(idump=4, 1 ,0)) as vyzov, ;
SUM(sumv_usl) as sumvs ;
from usl INNER JOIN straxs ON usl.idstrax=straxs.id AND straxs.inogor=.F. ;
inner join sp_tarif  on usl.code_usl=sp_tarif.ksg AND straxs.usl_ok=sp_tarif.idump ;
where straxs.usl_ok in (3,4,5,6) AND BETWEEN(MONTH(usl.date_out),lvmounth,lvmounth2) AND YEAR(usl.date_out)=lvyear and ;
straxs.smo=IIF(lvsmo=2,'05501',IIF(lvsmo=3,'05701',straxs.smo)) ;
group by usl.glpu, usl.mcod, usl.code_md

select count(distinct pol1) from ART where id=1

SELECT Count(distinct IIF(id=1,pol1,Cast(.NULL. as int))) FROM ART