I am searching for a query to find the details of highest paid employee in the entire organization. I am using oracle DB.
Queries which I tried are:
select * from EMP order by SAL desc FETCH FIRST 1ROW ONLY;
ERROR: SQL command not properly ended
select * from EMP order by SAL desc where rownum = 1;
ERROR: SQL command not properly ended
select * from EMP order by SAL desc LIMIT 0 , 1;
ERROR: SQL command not properly ended