Hi Guys,

Thanks a lot for your replies. Especially to 'Chrisrlong' for moderating and 'stecal' to pointing me that order by cannot be used directly with update.

SLIMDAVE's solution perfectly suites my requirement. Thanks SLIMDAVE.

Mirsat89 solution is fine if there is a 'key' field in the table. But unfortunately my table doesn’t have a key field.

I made some changes to my update statement based on SLIMDAVE's template and ran the update from SQLPLUS. It works's fine. Let me put this into my full application and see how it works.

I am really surprised by your overwhelming response.

Thanks for your help....!!!!!

-Football