select max(sal) from emp where sal < (select max(sal) from emp where sal

find out the third highest salary?

Question Posted / ravindra

Answer Posted / ravindra

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

0 No

Please Help Members By Posting Answers For Below Questions

Why do you use stored procedures and state some of its disadvantages?

1028

What to do if dba lost the system password?

1172

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2311

What is a dead lock in oracle?

1122

What is a parameter file in oracle?

1134

How to loop through a cursor variable?

1084

What do you understand by a database object?

1062

What is primefaces used for?

1049

what is the scenario where you take the database to NoArchivelog mode?

2331

What is the difference between PFILE and SPFILE in Oracle?

1060

What is an external table?

1020

What is the difference between primary key and unique key and foreign key in oracle?

982

What are the advantages of oracle?

1028

How to retrieve data from an explicit cursor?

1059

List out the components of logical database structure of oracle database.

1036