Write a query to who is taking more salary

Answer 1

sql query--> select person_name from table_name ORDER BY salary DESC;

after the execution of the above query the name at top is the person who is taking more salary than other.

Answer 2

select name from tablename where salary =(select max(salary) from tablename )

Answer 3

Select name from table_name order by salary desc fetch first row only