Thank you guys...

This time I pressurized the client to consider adding unique keys to the tables those don't have one already. And I think they are considering, because they asked me to look into the DB and list out all the tables not having a unique key :P. In this case, row_number() will work 🙂

Thanks for your valuable suggestions 🙂

Regards,

Snigdha