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

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

988

What is database dimension? : sql server analysis services, ssas

1032

Which autogrowth database setting is good?

1002

What are the types of containers in ssis?

1092

What is xml datatype?

1029

Call by value and call by reference in procedure and function, with NOCOPY.

1245

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

949

Do you know what is sql service broker?

995

What are the properties of sub-query?

1024

What is data source in connection string?

850

How much is a sql server license?

900

Explain four layers of abstraction microsoft architectured?

147

List the data types available in mssql?

957

What are subquery and its properties?

980

what happens on checkpoint? : Sql server database administration

1018