SQL命令以查找第二高的薪水 [英] SQL command for finding the second highest salary

问题描述

您能告诉我SQL命令的语法吗，该命令将雇员表中存储的一系列薪水作为第二高的薪水. 欢迎使用SQL commnd的描述... 请帮忙！！！

Can u tell me the syntax of the SQL command which gives as output the second highest salary from a range of salaries stored in the employee table. A description of the SQL commnd will be welcomed... Please help!!!

推荐答案

select min(salary) from 
(select top 2 salary from SalariesTable order by salary desc)
as ax

这篇关于SQL命令以查找第二高的薪水的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！