Deleting Duplicate Rows from Table

DELETE FROM ph_st_item a
WHERE rowid not in
(SELECT MIN(rowid)
FROM ph_st_item b
where  B.SV_NO = A.SV_NO and B.ITEM_CODE = A.ITEM_CODE
GROUP BY sv_no, item_code)

and substr(sv_no,1,2) = 'PP';