i need department wise top 2 employees salary.which logic
i will use
- 17 Answers
- 29581 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 column?
Is json a nosql?
Can we call procedure in select statement?
Write a query to find the names of users that begin with "um" in sql?
how many groups of data types? : Sql dba
What are different categories of sql commands?
What is microsoft t sql?
how do you control the max size of a heap table? : Sql dba
How to install oracle sql developer?
What is transaction control language (tcl)?
Explain the significance of the & and && operators in pl sql.
How do I view a sql trace file?
How do I find sql profiler?
What does cursor do in sql?
What is the clause we need to add in function body to return variable?
