返回具有最高薪水的员工的姓名和薪水的查询是什么 [英] what is the query to return Name and Salary of employee Having Max Salary

问题描述

1. 返回具有最高薪水的员工的姓名和薪水的查询

1. what is the query to return Name and Salary of employee Having Max Salary

推荐答案

SELECT Name, Salary FROM Minions
WHERE Salary = (SELECT Max(Salary) FROM Minions)

请注意，如果有多于一位雇员的最高工资相同，那么它将返回多行

Note that this will return more than one row if there is more than one employee who have the same max salary

这篇关于返回具有最高薪水的员工的姓名和薪水的查询是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！