donno whether the rest are correct ..but this one is:- select max(sal) fro

find out the third highest salary?

Question Posted / arijit

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

Answer Posted / arijit

donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));

Is This Answer Correct ?

52 Yes

17 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a parameter file in oracle?

1137

What is a dynamic performance view in oracle?

997

What is translate in oracle?

1101

What is enter substitution variable in oracle?

1057

What is an Oracle index?

1660

Why do you use stored procedures and state some of its disadvantages?

1028

Difference between varchar and varchar2 data types?

1189

What is primefaces used for?

1052

How to define and use table alias names in oracle?

945

What are the oracle differences between nvl and coalesce

1150

Why do we use bulk collect in oracle?

1063

How to login to the server without an instance?

1166

How to use values from other tables in update statements using oracle?

1085

please explain.. DB architecture ...

2029

How would you change old and new values in an insert, delete and update triggers?

1023