find out the third highest salary?
Answer Posted / ayaz mahmood
select max(sal) from emp
where sal= (select max(sal) from emp
where sal< (select max(sal) from emp
where sal< (select max(sal) from emp)))
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to open and close an explicit cursor in oracle?
What is memory advisor in Oracle?
How do I know if oracle is installed on windows?
Can group functions be used in the order by clause in oracle?
Explain coalesce function?
What is sharded cluster?
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.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to bring a tablespace online?
What are the different types of synonyms?
What is meant by an index?
What is oracle used for?
How to update a table row with a record?
Can objects of the same schema reside in different tablespace?
How to create an oracle testing table?