Row Duplicate(How to avoid) in table

select bcm_brcd,count(bcm_brcd) as dup_count  from vw_JSP_STOCK_SUMRY_TAX_INV_SALE where itm_id=101
group by bcm_brcd having (count(bcm_brcd)>1)