Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20417 Views
- HCL, I also Faced
- E-Mail Answers
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 is defined as Query studio?
which type of project we r going to snowflake schema
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Explain the different types of views used in cognos.
Explain what is the difference between native sql and cognos sql?
How is possible this scenario using in type-in prompt.?
What are the considerations regarding performance kept in mind while setting up cognos?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Can you define snapshot?
What is a Transformer?
What are slice and dice?
i have one file i saved in csv how can i take these file into framework manager
How can I test reports in cagonos?
What is the size of database for you project?
What is the difference between Open Connection command ang Open Session Command?
