Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country?
Thanks in advance
- 2 Answers
- 9770 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu
select * from ( select country,empname,salary, dense_rank() over (partition by country order by salary) rank from emp) where rank <= 2;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can you define bitmap index?
What do you mean by drill through report?
Why are meta service important then other services?
Mention the difference between ‘macros’ and ‘prompt’?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Diff b/w Crossproduct and Outerjoin?
What is meant by junk dimension?
What are the other methods working as deployment functionality?
What is model filter?
What is the difference between static and dynamic conditions?
Can you define fan trap?
Write various indexes used in cognos?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What are the advantages of using cognos sql?
Can you define confirmed dimension?
