can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Answers were Sorted based on User's Feedback



can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / dileep.t

If you need the second highest salary only
then following will also work,

select Max(Salary) from TableName
where Salary not in(
Select Max(Salary) from TableName)

Is This Answer Correct ?    18 Yes 3 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / preeti chauhan

CREATE TABLE T1(SALARY int, [NAME] varchar(50))
SELECT TOP 1 SALARY FROM (SELECT TOP 2 SALARY FROM T1 ORDER
BY SALARY DESC)T1 ORDER BY SALARY

Is This Answer Correct ?    15 Yes 3 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / kumar_kisna

select max(salary) from table where salary<(select max
(salary) from table)

Is This Answer Correct ?    4 Yes 1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / divya

select max(sal) from tablename where sal<(select
max(sal)from tablename)

Is This Answer Correct ?    3 Yes 0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / arun kumar ks

In the case more than one highest SALARY, only the Dilip’s
answer is correct.

Is This Answer Correct ?    3 Yes 1 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / sabin v jacob

SELECT Min(Sal) FROM (SELECT TOP 2 Sal FROM emp ORDER BY
Sal desc) as Temp

or

SELECT Min(Sal) FROM emp WHERE Sal IN(SELECT TOP 2 Sal FROM
emp ORDER BY Sal DESC)

Is This Answer Correct ?    5 Yes 3 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / rajendra

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc

Is This Answer Correct ?    2 Yes 0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / neeru

I think Daleep answer is not so precise, if you want 3rd or
ny specified answer, this only can only be seems right for
2nd highest salary, else, its not optimise query.I found
Preeti's query more optimistic and accurate.

Is This Answer Correct ?    1 Yes 0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / selvaraj.v

In SQL Server 2000 Query:
-------------------------

select max(salary) from Employee where salary not in(select
max(salary) from employee)

This Query only selects the 2'nd Higehest Salary in that
table. So, you will try...

Is This Answer Correct ?    1 Yes 0 No

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com..

Answer / harikumar

select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer



More SQL Server Interview Questions

when inserting to a table how many rows will be effected using triggers

2 Answers  


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  


what is datawarehouse?

0 Answers   Informatica,


Define full outer join?

0 Answers  


What is the purpose of grouping data in a report?

0 Answers  






Explain transaction server implicit?

0 Answers  


Explain temporary table vs table variable by using cursor alternative?

0 Answers  


What is data block and how to define data block size?

0 Answers  


Equi join and non equi join is possible with sql server?

0 Answers  


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  


What is Index Segmentation ?

1 Answers   TCS,


What is transact-sql language?

0 Answers  






Categories