For Finding Nth Salary... SELECT TOP 1 Salary FROM (SELECT TOP nth Sala

write query for fourth maximum salary from employee table

Question Posted / dharmendra k. dixit

Answer Posted / dharmendra k. dixit

For Finding Nth Salary...

SELECT TOP 1 Salary FROM
(SELECT TOP nth Salary FROM Table Order by Salary Desc)Table
As Sal Order by Salary

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Why do we use stored procedures in sql server?

910

What are sub reports?

192

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

119

What is partition index in sql server?

1073

What is the use of group by clause?

914

How to update muliple row in single query?

1017

What is the difference between a primary key and a unique key? Are they the same?

1030

List all the types of user-defined functions?

1028

Tell about MOM Tool(Microsoft Operator Manager)?

1873

What does it mean to normalize a database and why would you do it?

956

What are statistics?

967

What does <> symbol mean?

932

What is TDS(Tabular Data Stream) Gateway?

121

What is a coalesce function?

1146

In what version of sql server were synonyms released?

922