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
- 13226 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
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Does any body please help me what question's have asked for SSRS in the interview?
Do you know what is a trace frag? Where do we use it?
What is statement level trigger?
What is function of CUBE ?
What is the security model used in sql server 2005?
What is raid and what are different types of raid levels?
What is it’s similarity with sql server?
What is standby servers? Explain types of standby servers.
What is cursors?
What is transact-sql ddl trigger?
What are the different types of upgrades that can be performed in sql server?
What are the differences between having and where clause.
What are database states in ms sql server?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
