Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16583 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What is the difference between the content store and content manager?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
Tell me about Dnamic and Static Dashboards?
What is the size of database for you project?
What are all the types of gateway used in Cognos?
Explain about scorecarding?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What r the names of the reports that you prepared?
How do we convert from Numeric to be Words?
whats the difference between previous version of cognos and cognos 8 BI?
what is log in cognos?
Can you define folder?
How the Bursting happens in same report and how to Print the bursting Report?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is meant by drill down?
