select sal from employee where sal=(select min(sal) from employee where s

find out the third highest salary?

Question Posted / sabapathi

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

Answer Posted / sabapathi

select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List out the types of joins.

1083

how can we store any pdf file in oracle

2096

What is a dead lock in oracle?

1050

What is an oracle wallet?

882

Explain parameter file in oracle.

974

Can select statements be used on views in oracle?

985

What are the limitations oracle database 10g xe?

979

What are the benefits of ordbms?

1024

What is a table index in oracle?

1071

Whats the benefit of dbms_stats over analyze?

1935

State and explain about oracle instance?

930

State some uses of redo log files?

947

What are the differences between char and varchar2 in oracle?

1076

Describe the types of sub query?

939

What is oracle rowcount?

1037