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 migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Can you define folder?
how u will determine the performence tune will occur either in report or system
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is looping and how to avoid it in framework manager?
What is the metric store database?
Name the types of report?
Define datastores in cognos?
Explain the difference between powerplay transformer and power play reports?
What are the advantages of shortcuts?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
What is main difference mapplets and mapping?
Define query studio?