Interested to Buy Any Domain ? << Click Here >> for more details...
i need department wise top 2 employees salary.which logic
i will use
- 17 Answers
- 32269 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
How do sql databases work?
What is the sql*loader? : aql loader
What is the difference between sql and t sql?
What is scalar and vector?
What do you understand by pl/sql packages?
Which is better cte or subquery?
Explain the uses of database trigger.
Which command is used to call a stored procedure?
Why we use cross join?
How do I run a program in pl sql?
what is 'trigger' in sql? : Sql dba
what are different types of collation sensitivity? : Sql dba
Does truncate free space?
What trigger means?
Why join is faster than subquery?
