Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 32829 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sunil panghal
select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between sharding and partitioning?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What privilege is needed for a user to create tables in oracle?
How to export data to a csv file?
How to find the duplicate rows count from employees table in oracle?
How to get a list of all user accounts in the database?
Is oracle an open source?
How to unlock the sample user account in oracle?
What happens to the current transaction if the session is killed?
How is it different from a normal table?
What is an oracle tablespace?
What happens if the imported table already exists?
What is open database communication (odbc) in oracle?
How to pass a cursor variable to a procedure?
What happens if variable names collide with table/column names?
