Incorrect use of the TOP clause
927429Mar 30 2012 — edited Mar 30 2012Hi
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