薪水最低的员工SQL Server-不适用于MIN函数

请尝试从最低工资以下查询：

SELECt Top 1 emp_name, salary from Employee_salary order by salary

和

SELECt Top 1 emp_name, salary from Employee_salary order by salary desc

获得最高薪水。

如果有多名雇员的工资相同，请尝试：

SELECt Top 1 WITH TIES emp_name, salary from Employee_salary order by salary desc