delete from lc_ceric_b where l_mast_id in (
 
select l_mast_id from lc_ceric_b group by l_mast_id having count(*) > 1)