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 can you use check constraints for self referential integrity?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to do clean up if create database failed?
How to assign values to data fields in record variables?
What is a cursor and what are the steps need to be taken?
Please explain joins in oracle?
How to count duplicated values in a column in oracle?
Explain the difference between sap and oracle?
How to run create database statement?
How to write a query with an inner join in oracle?
Is postgres faster than oracle?
What is a package in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to select an oracle system id (sid)?
What is the sql query to concatenate column values from multiple rows in oracle?