write query for fourth maximum salary from employee table
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 |
Post New Answer View All Answers
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is database dimension? : sql server analysis services, ssas
Which autogrowth database setting is good?
What are the types of containers in ssis?
What is xml datatype?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Do you know what is sql service broker?
What are the properties of sub-query?
What is data source in connection string?
How much is a sql server license?
Explain four layers of abstraction microsoft architectured?
List the data types available in mssql?
What are subquery and its properties?
what happens on checkpoint? : Sql server database administration