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

find out the third highest salary?

Question Posted / lakshmi

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

Please Help Members By Posting Answers For Below Questions

What is an oracle user role?

1038

interview questions with answer for cts

2635

How to drop a tablespace?

1084

Is oracle a programming language?

1037

How can you use check constraints for self referential integrity?

1017

What is private procedure oracle?

1048

How to build data dictionary view an new database?

1050

What is save point in oracle database?

1364

6. Display the client name and order date for all orders using the traditional method.

2354

How to store only time; not date and time?

1067

What is the usage of synonyms?

1211

Can we insert data in view oracle?

1111

Can objects of the same schema reside in different tablespace?

1103

What is oracle in java?

1016

Can I create users through internet explorer in oracle 10g?

1155