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
- 32811 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / md valiyullah
select max(sal)-5 from emp where dept = 'sale'
union all
select max(sal)-5 from emp where dept = 'purchase'
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is IDE,DMV in sql server?
How can we find out the duplicate values in an oracle table?
How to lock and unlock a user account in oracle?
How to update values on multiple rows in oracle?
How to pass parameters to procedures in oracle?
What are transaction isolation levels supported by oracle?
What is connection pool in oracle?
How view is different from a table?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is a dynamic performance view in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
How to grant create session privilege to a user in oracle?
What is the usage of control file in oracle?
Why does oracle 9i treat an empty string as null?
