select max(company_id) from company where company

find out the third highest salary?

Question Posted / narendra

Answer Posted / narendra

select max(company_id) from company where company_id <
(select max(company_id) from company where company_id <
(select max(company_id) from company))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the extensions used by oracle reports?

998

Difference between the “verify” and “feedback” command?

1309

What is enter substitution variable in oracle?

985

What is an oracle tablespace?

985

Who developed oracle & when?

945

What are the system predefined user roles?

985

What to do if the binary spfile is wrong for the default instance?

1000

What does sharding mean?

947

What is redo log?

1007

What is the difference between hot backup and cold backup in oracle?

959

What is the quickest way to fetch the data from a table?

1001

What is a snapshot in oracle database?

974

How to get execution statistics reports on query statements?

1009

How to store pictures on to the database?

924

Explain oracle instance.

1108