I want to execute a query for the highest salary, when I execute the query I wrote, I get the following error:
SELECT TOP 3 salary FROM salary ORDER BY SALARY DESC;
And the error is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3 salary FROM salary ORDER BY SALARY DESC' at line 1
My query is correct but I am unable to understand the problem with this.