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

find out the third highest salary?

Question Posted / ram pravesh

92 Answers
150607 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get a list of all background sessions in the database?

991

What is archive log in Oracle?

1131

How to start a specific oracle instance?

1035

What are the different types of record groups in oracle? Explain each of them

1023

How to define an anonymous procedure with variables?

1155

How to use "in out" parameter properly?

1044

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2006

How to list all indexes in your schema?

1088

What are the tools for Oracle ?

1060

Explain a private synonyms?

1036

What are the roles of dba?

1065

Give the various rollback segment states.

1050

How to retrieve data from an explicit cursor?

1059

Explain the use of ignore option in imp command.

1035

What is the difference between Delete, Truncate and Drop in Oracle?

1129