SQL - Select name of the person with highest salary

Question

I have a table called workers which includes a few persons by their names, their salary and their working station. The table looks something like the following:

|Name|Station|Salary|
|Kyle|1      |2200  |
|Lisa|2      |2250  |
|Mark|3      |1800  |
|Hans|4      |1350  |

This might sound like a very obvious beginner question but I cannot get it work. I would like to select the name of the person with the highest salary. Thank you for reading, and have a nice one.

Answer 1

Select name 
from table 
where salary = (select max(salary) from table)

I dont know if you want to include ties or not (if two people have the same salary and it is the max salary.

What this does is find the max salary and then uses that in the query to find all people with that salary. You will need to replace the word table with whatever your table name is.

Answer 2

Try this

SELECT top 1 Name
FROM tableName
ORDER BY Salary DESC