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
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
What is looping and how to avoid it in framework manager?
what is degenerate key in oracle ?whare do we use it?
What do you mean by Drill down and Drill Up?
What is a dimension?
What is the difference between regular dimension and derminant?
how to perform back drill through in cognos 8 what is the use of it
What is Online View?
What is the size of database for you project?
Explain difference between powerplay transformer and power play reports?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What junk dimension contains?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What do you understand by the term 'model durability'?
How to select multiple values from type-in prompt?