Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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..

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..

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..

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..

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..

In the case more than one highest SALARY, only the Dilipâ€™s

 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..

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..

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..

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..

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..

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

 Is This Answer Correct ? 1 Yes 0 No

More SQL Server Interview Questions

What is sql server schema compare? How we can compare two database schemas?

What does nvl stand for?

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

Do you know what are pages and extents? : SQL Server Architecture

what changed between the previous version of sql server and the current version? : Sql server database administration

What are different types of raid levels?

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

What is a view?

What is a trigger and types of a trigger?

What triggers long term care?

What is normalization process?

What does REVERT do in SQL Server 2005?

Categories