3rd highest salary: select max(sal) from emp where sal

find out the third highest salary?

Question Posted / santanu

Answer Posted / santanu

3rd highest salary:

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use "in out" parameter properly?

1102

Can we create trigger on materialized view in oracle?

1042

What are the different types of record groups in oracle? Explain each of them

1069

How to insert a record into a table?

1120

How to use "if" statements on multiple conditions?

1217

How to delete a user account in oracle?

1021

Explain the use of record option in exp command.

1065

How can I see all tables in oracle?

1060

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1086

What is rich query?

1032

What are group functions in oracle?

1093

How do I reset a sequence in oracle?

1150

What is truncate oracle?

1014

What is a tns file?

1040

Please explain compound trigger in oracle?

1108