select max(amount) from ( select distinct amount from temp123 where rown

Find out the 3rd highest salary?

Question Posted / umesh naik

Answer Posted / umesh naik

select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)

Is This Answer Correct ?

1 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is rank () in sql?

536

What does count (*) do in sql?

528

Can you sum a count in sql?

560

What are the query optimization techniques?

535

what is the difference between clustered and non clustered index in sql? : Sql dba

551

What is pl sql in oracle?

585

What is spool?

592

Does inner join return duplicate rows?

521

Can we write dml inside a function in sql server?

501

Is sql considered coding?

569

Inline the values in PL/SQL, what does it mean.?

633

What is a clob in sql?

569

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

669

Can we use delete in merge statement?

515

Is a table valued function object?

583