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
How to insert data into an existing table?
What is inner join? Explain with an example?
What is the sql profiler?
What is the contrast amongst drop and truncate?
Explain what is dbcc?
What are the types of ssrs?
What is index, cluster index and nonclustered index?
What is sql server locking?
List out the differences between the clustered index and non-clustered index in sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
What are the authentication modes in sql server? How can it be changed?
What is an indexing technique?
How many tables can be joined in SQL Server?
What do you understand by integration services in sql server?
Tell me what is fill factor?