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

Difference between cartesian join and cross join?

1034

What is an oracle function?

1157

Explain compound trigger in oracle?

1037

What is an oracle transaction?

1139

What is a nvl function? How can it be used?

1029

How to export your connection information to a file?

1127

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2620

How to drop an existing view in oracle?

942

What are internal user account in oracle?

1004

What are the advantages of oracle?

1028

How to get a create statement for an existing table?

967

What is a trace file and how is it created in oracle?

1055

What is ceil and floor in oracle?

1069

How to use like conditions in oracle?

1053

How to use subqueries with the in operator using oracle?

1091