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

find out the third highest salary?

Question Posted / ram pravesh

Answer Posted / ram pravesh

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

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What types of joins are used in writing subqueries?

939

Explain the use of file option in exp command.

1081

What the is the diff between local index and global index. give some example.

1589

How to use windows user to connect to the server?

936

What are the predefined tablespaces in a database?

1011

What do you mean by a deadlock?

1009

What is the difference between hot backup and cold backup in oracle?

958

Is oracle an operator?

885

How many anonymous blocks can be defined?

1104

What are the oracle differences between nvl and coalesce

1069

What do database buffers contain?

964

How to delete a column in an existing table in oracle?

1011

How to use existing values in update statements using oracle?

1012

Explain the difference between sql and oracle?

1026

How to declare a local variable?

1055