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

find out the third highest salary?

Question Posted / punit chauhan

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

Please Help Members By Posting Answers For Below Questions

Explain oracle instance.

1107

How to run queries on external tables?

990

How to define an anonymous procedure without variables?

1025

What is a private synonym?

1531

How to convert characters to times in oracle?

955

How to create lov dynamically at runtime & attach to text field?

1098

What is the difference between $oracle_base and $oracle_home?

1029

How to write a query with a right outer join in oracle?

1113

How do I limit the number of rows returned by an oracle query after ordering?

1101

What is bind variable in oracle 11g?

995

What is index in Oracle?

1014

What is the difference between a user and a schema in oracle?

984

Explain what does a control file contain?

1034

How many anonymous blocks can be defined?

1104

What is columnar storage what is the advantage?

985