mysql - 选择列 MySQL 中具有最大值的行

Question

我有一个名为“employee”的表，我需要获取 Salary 的最大值以及该员工来自“New York”的行。

select * from employee where city = 'New York' and MAX(salary);

好像不行，求指教

Answer 1

试试这个:

select 
* 
from employee 
where city = 'New York' 
order by Salary desc limit 1