Want to ask your bosses, query the highest-paid employees in addition to
The select eno, salary from salary
Where salary=(select Max (salary) from salary)
Also can use what method?
I didn't want to check each department, I just want to check this company the highest salary of the worker

CodePudding user response:

You haven't used this query sector fields, actually this query is one of the best, is easy to understand, and other methods,

CodePudding user response:

Top company that this is ok.
The select Max (salary) from salary

CodePudding user response:

Directly select eno, Max (salary) from the salary

CodePudding user response:

Select the top 1 eno, salary from salary order by salary desc
A reverse, popular eton,