Delete Duplicate Records

delete
from transactions
where contribution_type_id =1
and action_id =1
and added_Date ='31-mar-2013'
and description  like '%Members Saving Regular%'
and rowid not in (
select max(rowid) from transactions
where contribution_type_id =1
and action_id =1
and added_Date ='31-mar-2013'
and description  like '%Members Saving Regular%'
group by member_id)