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 the user of Primary key?

1033

Give a example to search fr a string in all stored procedure in sql server.

1067

Write a query for primary key constraint with identity key word?

1084

How do I create an extended event in sql server?

1007

What are commonly used mssql functions in php?

1148

Explain how to use linked server?

1033

How to recover from sql injection? : sql server security

1072

What is the usage of sign function?

1179

Write a SQL queries on Self Join and Inner Join.

1077

List the advantages of using stored procedures?

1114

What is collation sensitivity? Explain different types.

1058

How to divide query output into multiple groups with the group by clause in ms sql server?

1094

Can we add a cpu to sql server?

1068

How to get a list of all tables with "sys.tables" view in ms sql server?

1088

Is it safe to delete log files?

978