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
What is the new security features added in sql server 2014? : sql server security
What is the need for indexing?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is sql injection? How to protect against sql injection attack?
How to call a function from a stored procedure in SQL Server ?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to filter out duplications in the returning rows in ms sql server?
Can you tell me about the concept of ER diagrams?
How to verify a user name with sqlcmd tool?
What are 3 ways to get a count of the number of records in a table?
What do you understand by sql server agent?
What is repeatable read?
What is surrogate key? : sql server analysis services, ssas
What are unicode character string data types in ms sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?