Select Top 1 * from Tbl_Salary where ID not in (Select top 1 ID 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 / bennison terry

Answer Posted / bennison terry

Select Top 1 * from Tbl_Salary where ID not in (Select top 1 ID from tbl_salary order by salary desc) order by Id desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define inner join? Explain with an example?

966

Do you know how to make remote connection in database?

948

What are user defined functions in ms sql server?

978

How will you decide the active and passive nodes?

1117

what types of replication are supported in sql server? : Sql server database administration

1022

how to use DTS package in 2000,2005,2008 in sql server

1823

How do you create a data source?

895

Which language rdl files made of?

128

What are the common performance issues in sql server?

902

How can we migrate from SQL server to SQL Azure?

113

What options are available to audit login activity? : sql server security

1138

How many triggers you can have on a table?

979

How to create an identity column?

1188

State the difference between union and union all?

922

Explain insert into select statement?

932