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 are the commands used in DCL?

1028

Define indexes?

1050

What is the sql server 2000 version number?

1084

what is the difference between a primary key and a unique key? : Sql server database administration

1010

What are sql server functions?

989

What is always encrypted?

1006

What is factless fact table? : sql server analysis services, ssas

1039

What is difference between index and primary key?

1103

Do you have any idea about the tcl commands?

967

Can we add a cpu to sql server?

1018

Can you explain important index characteristics?

995

Write down the syntax and an example for create, rename and delete index?

990

Can we shrink data file in sql server?

1054

What is the maximum rows in sql server table?

916

What is subquery in sql?

1074