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

find out the third highest salary?

Question Posted / ayaz mahmood

Answer Posted / ayaz mahmood

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

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

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

1076

Explain the difference between sap and oracle?

1087

What is a tns file?

1044

what is normalisation?what are its uses?

2334

Is primary key indexed by default in oracle?

1049

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1710

What is oracle rowcount?

1147

What to do if the startbd.bat failed to start the xe instance?

1128

How to create a table index in oracle?

1186

What is meant by raw datatype?

1119

Name the three major set of files on disk that compose a database in Oracle?

1171

How to resolve the ORA-39133 error in Oracle?

1184

What is data file?

1152

How do we create privileges in oracle?

1103

How to create a new oracle data file?

1076