Interested to Buy Any Domain ? << Click Here >> for more details...
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13287 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
How you can get a list of all the table constraints in a database?
What is Federation Root Database?
What is the difference between mysql and mysqli?
Tell me what is use of except clause? How it differs from not in clause?
Where sql server usernames and passwords are stored in a sql server?
what are the disadvantages of cursors? : Sql server database administration
What is a db view?
How will you add a dimension to cube? : sql server analysis services, ssas
Define full outer join?
How the authentication mode can be changed?
How can I know what locks are running on which resource?
What are the restrictions while creating batches in sql server?
Difference between Sql server reporting services and Crystal reports?
What are the rendering extensions of ssrs?
Do you know query execution plan?
