Find out the number of duplicates in the table:
select count(*), VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC
from TR00.NV_STARTER_INDEX
group by
VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC
having count(*)>1
DELETE
FROM TR00.NV_STARTER_INDEX
WHERE TR00.NV_STARTER_INDEX.%%physloc%%
NOT IN (SELECT MIN(b.%%physloc%%)
FROM TR00.NV_STARTER_INDEX b
GROUP BY VISTX_ST_FIPS, VISTX_CTY_FIPS, VISTX_TC)