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

How to update a table row with a record?

959

Explain about functional dependency and its relation with table design?

951

How to turn on or off recycle bin for the session?

1035

In which language oracle has been developed?

1013

What are a cluster and non-cluster index?

954

State some uses of redo log files?

940

How to best split csv strings in oracle 9i?

983

What is ordinary table in oracle?

1071

What is a view and how is it different from a table?

966

Why use resource manager in Oracle?

1049

What is where clause in oracle?

977

Can we commit inside a function in oracle?

914

What is a cognitive schema?

905

How to use subqueries with the in operator using oracle?

1029

What are a collation and state the different types of collation sensitivity?

1091