how to find nth highest salary
Answer Posted / ayush sharma
select sal from (select distinct sal from emp order by desc)
where rownum <=n minus select sal from(select distinct sal
from emp order by desc) where rownum<=n-1;
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Name few of the dcl commands in sql?
Explain triggers in sql?
Explain what is public role in sql server?
Explain how many types of relationship?
What are the database roles? : sql server security
How can we migrate from SQL server to SQL Azure?
What is a primary key?
Explain what is the purpose of sql profiler in sql server?
What is difference between Datepart() and Datename() in SqlServer?
What is spid in sql server profiler?
Can we call future method from trigger?
What purpose does the model database server?
How to add additional conditions in SQL?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is cursors?