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
How to delete a column in an existing table in oracle?
Explain coalesce function?
What is an oracle and why it is used?
Difference between pre-select and pre-query
How to store only time; not date and time?
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.
Give the different types of rollback segments.
How to export data with a field delimiter?
What are the arithmetic operations?
what is insert all statement in sql
How to execute a stored program unit?
What is the parameter mode that can be passed to a procedure?
Where do you use decode and case statements?
How to use subqueries with the in operator using oracle?
Can select statements be used on views in oracle?