Select Top 1 salary from (Select TOP 2 salary from tbl

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 / belson gnana pradeep

Answer Posted / belson gnana pradeep

Select Top 1 salary from (Select TOP 2 salary from tbl_salary order by salary desc)a order by salary

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is named calculation? : sql server analysis services, ssas

1021

What do you mean by acid?

1055

How do you make a trace?

1073

What are the five characteristics of good data?

969

What does select 1 mean?

976

What is db stored procedure?

943

Do you know what is rank function?

1124

Explain the first normal form(1nf)?

1076

What happens if ntwdblib.dll is missing on your machine?

1187

What are the dmvs? : sql server database administration

1118

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1107

What are “phantom rows”?

1703

what exactly sql injuction.how to overcome.....

2595

Find first and last day of current month in sql server

1080

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1195