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
- 9840 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
how to perform back drill through in cognos 8 what is the use of it
what are the names of the reports that you prepared?
What is a Framework manager?
Define query studio?
What is main advantage datawarehousing over oracle?
How to generate cubes in cognos?
What are the batches and it’s details?
--------------Explain Table of contents?
what is catalog and types of catalogs in cagnos and which is better?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Can you explain dynamic query mode?
in u r data u having duplicates how to fetch the latest data in our report?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Write some methods to apply securities in framework manager model?
What is the complex report you faced in real time?
