how to find nth highest salary
Answer Posted / deepak dabi
I Think this is the best solution ever i have seen ,i
appriciate if you prove me wroong on this so,otherwise i got
all other a bit wrong ,in many cases please try this....
"SELECT distinct(sal) from emp order by sal desc limit 2,1"
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Tell me in brief how sql server enhances scalability of the database system?
How to enter comments in transact-sql statements?
Explain four layers of abstraction microsoft architectured?
Define msdb database?
What do you understand by a view?
What is postgresql server?
How can we delete Duplicate row in table?
What are .mdf files?
What is an expression in ms sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How to disable a login name in ms sql server?
What are the options which must be set to allow the usage of optimistic models?
Is sql server difficult to learn?
Can we use max in where clause?