how will I find the first 5 highest salaried employees in
each dept in oracle.
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
Query to retrieve record for a many to many relationship ?
 What are the oracle DML commands possible through an update strategy?
How to delete an existing row from a table in oracle?
How to estimate disk space needed for an export job?
How to do paging with oracle?
What is a package in oracle?
What are group functions in oracle?
How to create a table index?
How to select some rows from a table in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to convert a date to char in oracle? Give one example.
What is a database table in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How do I find the database name in oracle?
How to store only time; not date and time?