delete from saf_ghasedak where rowid not in (select max(id) FROM saf_ghasedak where state='1' GROUP BY mobile having COUNT(*) > 1 );