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
- 31511 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 rowid in sql?
What is sql clause?
How to Declare Fixed Length String Value In PL SQL
What is string data type in sql?
What is normalization in a database?
What is string join?
What are the usages of sql?
How is a process of pl/sql compiled?
What is pl/sql language case sensitive?
Cite the differences between execution of triggers and stored procedures?
What are the ways on commenting in a pl/sql code?
What is natural join in sql?
how to see the create table statement of an existing table? : Sql dba
Are stored procedures compiled?
What is the difference between drop and truncate commands?
