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

find out the third highest salary?

Question Posted / mahesh

Answer Posted / mahesh

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

Is This Answer Correct ?

11 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Explain about functional dependency and its relation with table design?

955

candidate key is subset of super key but not vice-verse explain

2019

How to rename a tablespace in oracle?

1036

What is MTTR advisor in Oracle?

1036

How to start an oracle instance?

955

What is merge in oracle?

997

List the parts of a database trigger.

991

Which are the five query types available in oracle?

900

Explain the use of compress option in exp command.

969

Why should I use oracle database?

948

What is a cursor variable?

1048

What are the different types of trigger and explain its various uses and functions?

1010

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

What is oracle in java?

913

Explain joins in oracle?

987