本文介绍了SQL命令以查找第二高的薪水的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您能告诉我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命令以查找第二高的薪水
发布评论