find out the third highest salary?
Answer Posted / manoj
select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
State the difference between a primary key and foreign key?
How to create a new tablespace in oracle?
how may join possible between (requisition with purchase order)
How to write numeric literals in oracle?
Difference between the “verify” and “feedback” command?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to upsert (update or insert into a table)?
What are the general rules on data consistency?
What is Reduced List of Values?
How would you go about verifying the network name that the local_listener is currently using?
How do I spool in oracle?
How to create a testing table in oracle?
How to concatenate two text values in oracle?
What are the differences between lov and list item?
Difference between cartesian join and cross join?