consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 26816 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / ashim
select * from (select id,dept,sal,dense_rank() over
(partition by dept order by sal desc) p from a_tab1)
where p=1
....by using this program we can find out the nth salary of
different department jus give p=n
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of functions are there in sql?
How do I view output in sql developer?
How do I run a pl sql program?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is right join in sql?
How to create a menu in sqlplus or pl/sql?
Can %notfound return null after a fetch?
What is a database? Explain
Explain the insert into statements in sql?
what are the differences between binary and varbinary? : Sql dba
How long it takes to learn pl sql?
What is optimistic concurrency control? : Transact sql
What is sharding in sql?
What is minus?
How show all rows in sql?
