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

find out the third highest salary?

Question Posted / sukanya

Answer Posted / sukanya

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

Please Help Members By Posting Answers For Below Questions

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

What is execute immediate in oracle?

951

What are the set operators union, union all, minus & intersect meant to do?

939

How to use regular expression in pattern match conditions in oracle?

977

How do I escape a reserved word in oracle?

1132

How many types of database triggers exist?

1068

What is the purpose of save points in oracle database?

1007

What are the benefits of ordbms?

1024

What is a server parameter file in oracle?

1004

How can I create database in oracle?

961

What is an Oracle index?

1606

Is rowid unique in oracle?

939

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4482

What are nested tables?

1107

Can objects of the same schema reside in different tablespace?

1002