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
What is 2nf example?
Where in ms sql server is ’100’ equal to ‘0’?
What are truncate options available in sql server? : sql server database administration
Tell me what is the difference between locking and multi-versioning?
What is difference between foreign key and unique key?
What are the differences between stored procedure and the dynamic sql?
What are the properties of the transaction?
How does index makes search faster?
What is format parameter in ssrs?
How to delete exactly duplicate records from a table?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
How can you find out how many rows returned in a cursor?
What is t-sql script to take database offline – take database online.
Describe and explain about SQL native client?
What is the concept of optimization?