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

find out the third highest salary?

Question Posted / mahesh

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the implicit cursor in oracle?

1105

What is private procedure oracle?

1010

Explain an exception and its types?

1073

How to create an oracle database?

1041

Why should I use oracle database?

991

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

How many types of table in Oracle?

1122

How to use "for" statements in oracle?

1074

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

IS it possible to built the oracle database without setting the kernal parameters?

2348

What is logical backup in oracle?

1017

What is hash cluster in oracle?

1174

Please explain oracle data types with examples?

1069

What is the relationship among database, tablespace and data file?

989

How can we delete duplicate rows in a table?

973