Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17538 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 the difference between list report and crosstab report?
What are the advantages of using cognos sql?
Explain the characteristics of cognos?
What is defined as Cognos Impromptu?
What is the deployment requirements used in cognos?
What is the use of powerhouse?
What do you mean by drill through report?
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..
what is the role of cognos comsultant?what actually it means?pls reply
what are slowly changing dimensions? Why we are used scd?
Can you define folder?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How we check the errors before running the report?
how to create measures and dimensions?
what is the procedure for scheduling conditional rendering?
