find out the third highest salary?
Answer Posted / gaurav
try this
select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between char and nchar in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
Why do we use bulk collect in oracle?
How to open and close an explicit cursor in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to convert characters to numbers in oracle?
What is a trigger oracle?
What is user managed backup in Oracle?
Explain implicit cursor.
What is the purpose of save points in oracle database?
What is a trigger and what are its types?
How different is ms access and oracle?
How to sort output in descending order in oracle?
How many types of synonyms in Oracle?
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.