Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 30189 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 you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can we join tables without foreign key?
Can you rollback after commit?
What does plv msg allows you to do?
What is anonymous block in sql?
Is vs as in pl sql?
What is a recursive stored procedure?
what is recursive stored procedure? : Sql dba
What is on delete restrict?
Which join is like an inner join?
What is a delimiter in sas?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is clustered index in sql?
What is difference between db2 and sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
