how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / uttam
select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6
| Is This Answer Correct ? | 13 Yes | 15 No |
Post New Answer View All Answers
How to insert a record into a table?
How to run the anonymous block again?
Can multiple cursors being opened at the same time?
What are transaction isolation levels supported by oracle?
What privilege is needed for a user to create views in oracle?
State and explain about oracle instance?
How to connect the oracle server as sysdba?
What privilege is needed for a user to delete rows from tables in another schema?
What is bulk collect in oracle?
How to assign data of the deleted row to variables?
What is the difference between pre-select and pre-query?
How can Oracle users be audited?
How to add another datafile to a tablespace?
What is the database name in oracle?
List out the types of joins.