how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / nagaraju nampally
select * from (select ename,sal,deptno,dense_rank()
over(partition by deptno order by sal)rnk from emp)x where
x.rnk<5
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give the advantages and disadvantages of clusters.
definition of cluster and non-clustered index?
How to write a left outer join with the where clause in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is the usage of merge statement?
In which language oracle has been developed?
How to concatenate two text values in oracle?
Are truncate and delete commands same? If so why?
How to import one table back from a dump file?
How to find the duplicate rows count from employees table in oracle?
How can we find out the duplicate values in an oracle table?
What are the parameters that we can pass through a stored procedure?
How to Truncate Table in Oracle
What is an anonymous block?
How to connect the oracle server as sysdba?