您能告诉我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