find out the third highest salary?
Answer Posted / santanu
3rd highest salary:
select max(sal) from emp
where sal < (select max(sal) from emp
where sal < (select max(sal) from emp))
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of auditing in Oracle?
How to use attributes of the implicit cursor in oracle?
How to define an explicit cursor in oracle?
What is Segment Advisor in Oracle?
How to speed up webrick?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to do clean up if create database failed?
What is connection pooling in oracle?
What is archive log in Oracle?
What is memory advisor in Oracle?
What is a nvl function?
What are the uses of Database Trigger ?
What is the difference between a primary key & a unique key?
Name the three major set of files on disk that compose a database in Oracle?
Write a trigger example in oracle?