write query for fourth maximum salary from employee table
- 14 Answers
- 20614 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
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 difference between standardization and normalization?
What do you understand by replication in sql server?
What is the exact numeric data type in sql?
Is it true, that there is no difference between a rule and a check constraint?
What happens when converting big values to numeric data types?
What are horizontal and vertical scaling?
Detail about query optimizer?
What are the reporting services components?
What is a trigger? Why we need it?
what is database replicaion? : Sql server database administration
How do I view a script in sql server?
How to create indexed view?
What is catalog views?
Mention what are the different types of ssrs reports?
How to add code to the existing article (using improve article)?
