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
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is a Query Subject?
What is the deployment requirements used in cognos?
What is cognos powerhouse?
7. What is performance tuning?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Write some methods to apply securities in framework manager model?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What is difference between data mart and data warehouse?
Explain what is the difference between native sql and cognos sql?
------------ Diff b/w MemberCaption and MemberDescription?
Can you define folder?
How create measures and demensions?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is the importance of having monitor service in cognos?