列中第二高的数字

本文介绍了列中第二高的数字的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

任何机构都可以告诉我如何从sql server 2005的列中找到第二高的数字吗? 否 - 10 20 40 60 答案应该是40

Can any body plz tellme how we can find the second highest number from column in sql server 2005? No -- 10 20 40 60 the ans should be 40

推荐答案

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY < (SELECT MAX(SALARY) FROM EMPLOYEE)

SELECT SALARY FROM Employee t1 WHERE 2=(SELECT COUNT(DISTINCT t2.SALARY) FROM Employee t2 WHERE t2.SALARY >= t1.SALARY)

我已经给出了在这个线程中.检查一下 点击此处 I have given this ans in this thread. Check it out click here