Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
Answer Posted / sumathy
Am Sumathy the above answer was posted by me.
For the above Answer 'absolute 2' will fetch 2nd maximum
value.
To fetch 4th maximum value use 'absolute 4'
To fetch 'n'th maximum value use 'absolute n'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain tablesample?
How to get nth highest salary from employee table.
How many non clustered indexes there can be on table ?
What are the steps to process a single select statement?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is executereader?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Why main is user defined function?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
what is a mixed extent? : Sql server administration
What is SQL Azure Data sync?
What is difference between standardization and normalization?
What is serializable?
How to implement service broker?