SELECT employee_name
FROM employees
WHERE year = 2019
ORDER BY (salary - (SELECT salary FROM employees WHERE employee_id = e.employee_id AND year = 2018)) / (SELECT salary FROM employees WHERE employee_id = e.employee_id AND year = 2018) DESC
LIMIT 1;
解释: 该查询首先从员工表中选择年份为2019年的员工,并按百分比涨幅降序排序。百分比涨幅计算方法为2019年薪水减去2018年薪水的差异除以2018年薪水。查询返回结果集中的第一行即为年薪涨幅最大的员工。