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

17 Answers
20558 Views
HCL, IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database white box testing?

1079

What are the types of subquery?

990

What is a data source or ds? : sql server analysis services, ssas

952

What are sp_configure commands and set commands?

959

What are system databases into sql server (2005/2008) : sql server database administration

967

what is the maximum size of a row? : Sql server database administration

944

How to create a simple user defined function in ms sql server?

971

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1014

What is clr ddl trigger?

914

What is difference between count (*) and count 1?

867

What do you know about normalization and de- normalization?

871

In what sequence sql statement is processed?

957

What is a collation?

1038

Difference between Inner vs outer joins?

895

Do you know what is similarity and difference between truncate and delete in sql?

961