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

How to define an oracle sub procedure?

1141

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1864

State some uses of redo log files?

1001

How to use subqueries with the in operator using oracle?

1091

Write a trigger example in oracle?

1058

Explain constraining triggers.

1092

what are the default admin accounts in Oracle 10g ?

967

How to join two tables in a single query using oracle?

995

What is raw datatype in oracle?

1133

How to start your 10g xe server from command line?

1073

Which are the five query types available in oracle?

949

What are the differences between char and varchar2 in oracle?

1169

What is tns name?

980

How to create a stored program unit?

1224

What is columnar storage what is the advantage?

1059