Dear all,

here i have a small requirement for deletion of duplicate records.

I have a table like

conntract_id objectid member age
11111111 000000 father 55
11111111 000001 mother 50
11111111 000002 brother 36
11111111 000003 brother 33
11111111 000004 sister 31
11111111 000005 father 55
11111111 000006 sister 31


in the above i need to delete the records which are duplicate member name
and if age is same then we have to delete the record.
and moreover that is not a PK.

i am able to select the the single records using like this. other than these records need to delete.

SELECT MEMBER, age
FROM azbj_policy_family_rep
WHERE contract_id = azbj_pk0_acc.get_contract_id('0110122421')
GROUP BY MEMBER, age;

please suggest on this, how do i delete the records other than these records.

Regards,
Venkat

@venkat,

In oracle SQL,

The following query will resolves your problem

Thanks Alot,