find out the third highest salary?
Answer Posted / punit chauhan
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
punit chauhan
iMS NOIDA
doing MCA
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How to login to the server without an instance?
How to select an oracle system id (sid)?
Can I create users through internet explorer in oracle 10g?
what is the difference between restoring and recovering?
What is oracle join syntax?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is program global area (pga) in oracle?
What's dateware house and what's clustor with practicle example
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is a database schema in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
ABOUT IDENTITY?
various types of hints and their usage
Where do we use decode and case statements?
What is the use of file param in imp command?