Hi All,
I got a requirement to remove the duplicate records , I have over hundreds of duplicate records in u_laboratory_id table, there are more than one record for each lab id with duplicate active '1' flag , but there should be only one active flag '1' record so I need to keep the records which are having highest rowid and need to cleanup the remaining ones.
Please help with the script or if you have any other method to resolve this , Please let me know.(Iam attching the image here for example I have filterd one lab id there).
