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
- 12956 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
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are four major operators that can be used to combine conditions on a where clause?
What are the different normalization forms?
What is data modeling and Reterminal integrity?
How do I shrink an ldf file?
Can group functions be mixed with non-group selection fields in ms sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How do you migrate data from mssql server to azure?
What is the command used to check locks in microsoft sql server?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Does order by actually change the order of the data in the tables or does it just change the output?
What is the difference between for trigger and after trigger?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to use union to merge outputs from two queries together in ms sql server?
What is an expensive query?
