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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
261 views