Skip to Main Content

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!

Incorrect use of the TOP clause

927429Mar 30 2012 — edited Mar 30 2012
Hi

I need to demonstrate the use of the TOP clause, however when I run my SQL it says incorrect use of the clause.

Question: List the top 3 earners in the company( from the employees table). List employee_id, last_name, and the salary in descending order.

below is my attempt:

Select TOP 3 employee_id, last_name, salary
FROM employees
ORDER BY salary DESC;

Any assistance will be appreciated

Thanks
This post has been answered by MichaelS on Mar 30 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2012
Added on Mar 30 2012
14 comments
308 views