select distinct top 1 salary from payroll..emp where salary in(select dis

from the table display the 2nd highest salary?
and also the least 2nd salay?

Question Posted / sridhar sahoo

Answer Posted / sridhar sahoo

select distinct top 1 salary from payroll..emp where salary
in(select distinct top 3 salary from payroll..emp order by
salary desc)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1151

how will add additional conditions in sql?

1111

Is candidate a key?

957

How to create new databases with "create database" statements?

1029

Which are the two editions in which SQL Azure database available?

119

What are the advantages of using stored procedures in sql server?

1014

What is encryption key?

132

What is nonclustered index with included columns ?

970

What is query optimizer in sql server?

1030

what stored procedure would you use to view lock information? : Sql server administration

978

How can you control the amount of free space in your index pages?

1060

How do I view a procedure in sql server?

996

How do you set a trace flag in sql server?

1041

What is enhanced database mirroring in sql server 2008?

976

How many ways to create table-valued functions?

1000