select min(salary) from (select top 2 salary from phani order by salary de

write the query for find the top 2 highest salary in sql
server

Question Posted / mohan c v

Answer Posted / mohan c v

select min(salary) from
(select top 2 salary from phani order by salary desc) as a

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does null mean?

993

What is a join in sql?

1103

What are the advantages of the mirroring?

1097

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

988

What are different types of table joins?

1021

What programming language would you use to create embedded functions in ssrs?

186

Which are new data types introduced in sql server 2008?

1057

Which are the important points to note when multilanguage data is stored in a table?

1006

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2761

Can we use pragma autonomous_transaction in trigger?

971

what is the main function of a query parameter?

155

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2513

What is the difference between DataRow.Delete() and DataRow.Remove()?

1234

What do you mean by table and field in sql?

1019

How to retrieve error messages using mssql_get_last_message()?

1061