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 does trigger mean in slang?
what is a tablespace? : Sql dba
What is the reports view in oracle sql developer?
Is pl sql and postgresql same?
Is pl sql different from sql?
how to get a list of all tables in a database? : Sql dba
State some properties of relational databases?
what is 'mysqlcheck'? : Sql dba
Describe types of sql statements?
How can we make an if statement within a select statement?
How do you add a column to a table?
Explain autonomous transaction.
What is difference between joins and union?
what are integrity rules?
What is an ndf file?