how to find second maximum salary from a table.

Question

how we can find second maximum salary from the table like table name is customer.

Upendra Pratap Shahi · Answer

1-SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee ) 2-select MAX(Salary) from Employee WHERE Salary (select MAX(Salary) from Employee ) 3- select max ( salary ) from emptable where salary ( select max ( salary ) from emptable ); 4- SELECT * FROM ( SELECT [ Salary ],( DENSE_RANK () OVER ( ORDER BY [ Salary ] DESC )) AS rnk FROM [ Table1 ] GROUP BY [ Num ] ) AS A WHERE A . rnk = 2

Pankaj Kumar Choudhary · Answer

Hello Saurabh there is 2 method you can use any one select Min(Salary) from (Select Top(2) Salary From customer Order By(Salary) Desc)Tab Select Top 1 Salary From (Select distinct Top 2 Salary From customer Order by Salary Desc)Tab Order By Salary Asc

Upendra Pratap Shahi · Answer

@pritaeas thanx..

pritaeas · Answer

@Upendra Pratap Shahi: +1 for no. 4 !

Rajeesh Menoth · Answer

Hi, SELECT max ( salary ) FROM customer WHERE salary NOT IN ( SELECT max ( salary ) FROM customer ) ; More details : http://javarevisited.blogspot.in/2012/12/how-to-find-second-highest-or-maximum-salary-sql.html

pritaeas · Answer

Something like this: SELECT TOP 1 salary FROM customer WHERE salary ORDER BY salary DESC

how to find second maximum salary from a table.

Answers (6)