query error!
select
Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt),
BrandKor= max(BrandKor)
from psBrandMainBatch
where
ViewYes=1
and Rcnt >= 1
group by BrandID
order by BrandID
select
Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt),
BrandKor= max(BrandKor)
from psBrandMainBatch
where
ViewYes=1
and Rcnt >= 1
group by BrandID
order by BrandID
select
Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt),
BrandKor= max(BrandKor)
from psBrandMainBatch
where
ViewYes=1
and Rcnt >= 1
group by BrandID
order by BrandID
