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 cross join? : Sql dba

998

what are the difference between clustered and a non-clustered index? : Sql dba

1033

What is the difference between rollback and rollback to statements?

1060

What is rtm stands for?

1100

What are the sql commands?

1182

How do I add a primary key to a table?

1042

What is the largest value that can be stored in a byte data field?

1012

how do you tune the slow running queries in oracle db , explain the methodology

2800

What is a rank in sql?

964

Do foreign keys improve performance?

1026

What is difference between procedure and trigger?

982

Is grant a ddl statement?

897

What is sap sql anywhere?

1080

What is trigger price?

989

Can function return multiple values in sql?

1061