i need department wise top 2 employees salary.which logic
i will use
- 17 Answers
- 33071 Views
- I also Faced
- E-Mail Answers
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 is bcp? When does it used? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is the current version of sql?
How do I remove duplicates in two columns?
what is sql server agent? : Sql dba
what is collation? : Sql dba
how to escape special characters in sql statements? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What is the current version of postgresql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is primary key clustered index?
Is primary key always clustered index?
What is the best sql course?
What is your daily office routine?
how to start mysql server? : Sql dba
