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
- 9975 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
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Can you define set to be cardinality?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Give me any example of semi and non additive measures?
What is defined as data mining?
What is model filter?
What is the difference between the standard and metrics folder?
4. How many dimensions did you use in your reports?
-------------What is Coditional Prompting?
What is difference between page break and section report?
How do we convert from Numeric to be Words?
How do you call a store procedure within a transformation?
Can you define cognos impromptu?
What is cognos powerhouse?
