Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 11923 Views
- I also Faced
- E-Mail Answers
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 1nf 2nf?
can any body tell me how to know the password of current user in sql server
What is candidate key with example?
what is a self join? : Sql server database administration
What sql server means?
How to insert new line characters into strings?
What are the different types of data sources in ssrs?
How you would rewrite the sql query to return the customerid sorted numerically?
What is normalization? Describe its different types.
What area unit the various kinds of info compression introduced in sql server 2008?
How to update a field in SQL after ALTERING a row?
How to generate random numbers with the rand() function in ms sql server?
How use inner join in sql server?
Explain what is “asynchronous” communication in sql server service broker?
How to manipulate data from one table to another table ?
