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
- 32010 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 to concatenate two character strings? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How does a self join work?
What is 19 null in sql?
What is loop in pl sql?
What is varchar sql?
Does sqlite need a server?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is function and procedure in pl sql?
What is vector point function?
Explain the uses of a database trigger?
How do I run a sql script?
What is user in sql?
What is a scalar value in sql?
How do you create a db file?
