How do I get Distinct entries from Duplicate records?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hello Guys; I have a table which contains duplicate entries (almost all) but with a differentiating PK & another 1 column. Below is the sample of what I have ID Narration RenewalCount Renewed 1 ABC 1 0 2 ABC 1 0 3 ABC 0 0 4 PQR 1 0 5 PQR 0 0 Now, I need to get distinct entries from this table as given below ID Narration RenewalCount Renewed 3 ABC 0 0 5 PQR 0 0 The idea is for me to set Renewed column = 1 for the rest of the records in the table.