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
- 13267 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 run a trace?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Mention the different types of triggers?
what is raid? : Sql server database administration
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How to replace the Query Result 'Null Value' with a text ?
What samples and sample databases are provided by microsoft?
How to use subqueries in the from clause in ms sql server?
What are clustered and non-clustered index?
Would you store your query in a ssrs report or a database server? State the reason why?
do views contain data ?
How to download and install microsoft .net framework version 2.0?
What is the use of @@spid?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is the default value of an integer data type in sql server 2005?
