drop table #temp select top 2 identity(int,1,1) as SlNo, * into #temp f

I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000

Question Posted / deepa

Answer Posted / deepa

drop table #temp
select top 2 identity(int,1,1) as SlNo, *
into #temp from employee order by salary desc
select * from #temp where SlNo = 2

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the dis_advantages of stored procedures, triggers, indexes?

2170

What is filtered index?

1038

What is candidate key with example?

921

What are different types of views?

891

What is logshipping and its purpose?

942

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1061

How to apply filtering criteria at group level with the having clause in ms sql server?

943

What is forward - only cursors / read only cursor?

1019

What is temporal table?

819

What to perform pattern match with the like operator?

837

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

980

What is federation member?

114

What function does a database engine serve in the sql server?

984

What are the indexes in sql server?

1019

What is correlated subquery in sql server?

1013