Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 10987 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 do you delete duplicate rows in sql server?
What are two difference between sql azure and azure tables?
What are data files?
How to find which stored procedure is currently running in sql server?
Describe the functionalities that views support.
Explain how to send email from sql database?
Where is localdb stored?
How to get a list all databases on the sql server?
What is the latest version of microsoft sql server?
How to connect ms access to sql servers through odbc?
Explain about builtinadministrator?
What is the difference between stored procedure and functions?
What is the web service used for reporting services?
Define clusters?
What are different types of statement?
