Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to update top 5 records

pnrDec 1 2009 — edited Dec 1 2009
Hi

I have table with empno,sal,flag columns.
I need to update top "n" sal records with flag status=1.

Thanks
nr

Edited by: pnr on Dec 1, 2009 2:00 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2009
Added on Dec 1 2009
10 comments
18,125 views