Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / prashant
SELECT min(salary)
from emp
where salary in (select distinct top 5 salary from emp
order by salary desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what are the dimensions that you have in your current project?list them?
hi friends pls forward impropmtu interview question
What is the advantage of using shortcuts?
What are the types of catalogs in cognos?
How is possible this scenario using in type-in prompt.?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
what is stitch query in reportnet?
Can you explain dynamic query mode?
What is looping and how to avoid it in framework manager?
what is a prompt value in report studio and variables ?
Explain what is the main advantage of impromptu over cognos reportnet?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What is Fullouterjoin?
What is a Transformer?
What are shortcuts? Where it can be used? What are the advantages?