i need department wise top 2 employees salary.which logic
i will use
Answer Posted / ethayan
select foracid,clr_bal_amt from (select
foracid,clr_bal_amt,rank() over (order by clr_bal_amt desc
nulls last) as ranking
from tbaadm.gam order by a,clr_bal_amt nulls last)
where ranking=2
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are different types of triggers?
How many row comparison operators are used while working with a subquery?
What is the usage of when clause in trigger?
What are functions in sql?
What does select top 1 do in sql?
What is the basic form of sql query?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the difference between rename and alias?
How many types of indexes are there in sql?
What does count (*) mean?
Which data type is a composite type?
Explain normalization and what are the advantages of it?
What is the difference between distinct and unique in sql?
What is a relationship and what are they?
What is pl sql code?