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

find out the third highest salary?

Question Posted / lakshmi

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

Answer Posted / lakshmi

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

Is This Answer Correct ?

94 Yes

135 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to recover a dropped table in oracle?

1042

What is a server parameter file in oracle?

1055

Which environment variables are absolutely critical in order to run the OUI?

2118

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

In the oracle version 9.3.0.5.0, what does each number shows?

1297

How can I get column names from a table in oracle?

1048

How to update values on multiple rows in oracle?

1034

What are the different pseudo commands? Explain in general?

1074

Explain the features of oracle?

1038

Explain the use of record option in exp command.

1006

What happens to the indexes if a table is recovered?

991

Can we commit inside a function in oracle?

962

How many types of synonyms in Oracle?

1119

How to write a query with an inner join in oracle?

1038

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

1010