Using procedure delete the duplicate record based on phone no(unique) by selecting with least count of each column.
The requirement is
For person a
1st row has - 4 records
2nd row has - 5 records
3rd row has - 6 records
4th row has - 7 records
5th row has- 8 records
6th row has - 9 records
have attached the table as image format.
I need to delete all rows except 6th one. since all the rows has least information of the person except the sixth.
and then which has delete the duplicate record and store into new table. Kindly help.