hi

Hello,

Here I have a few sample data.

C_ID--- Customer ID is unique

C_PHONE--- Customer Phones are sometimes duplicates or more than even two time

B_POINT--- got Point balance is according to customer ID and Customer Phone number

What I need is,

1) I want to keep the Customer's Phone number which has the highest Balance Point (Remove Duplicate mobile number as per the highest Balance Point)

Expected Outcome for Highest, 

2) I want to keep the Customer's Phone number which has the lowest Balance Point (Remove Duplicate mobile number as per lowest Balance Point)

Expected Outcome for Lowest, 

Thanks