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
- 31978 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
Hi Can any one tell me what are the API's used in requisition import.
Can we create database in oracle using command line ?
What is a schema in oracle?
What is a user account in oracle?
What is control file used for?
How to call a stored function in oracle?
What is a database schema in oracle?
Difference between cartesian join and cross join?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What do database buffers contain?
how the indexes are stored in the Oracle Database?
How to omit columns with default values in insert statement in oracle?
What is the usage of analyze command in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to rename a tablespace in oracle?
