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 do you mean by rowid?

956

How can you fetch common records from two tables?

1051

What are the uses of sysdate and user keywords?

1087

Why do we create stored procedures & functions in pl/sql and how are they different?

928

What is pl sql record in oracle?

1015

What is record data type?

901

What are basic techniques of indexing?

1366

What is the difference between mdf and ndf files?

1101

What are the methods of filing?

921

Why do we use procedures?

943

What is normalization sql?

1044

Can we join tables without foreign key?

950

Is like operator in sql case sensitive?

1003

What is the difference between delete and truncate statement in sql?

1049

What is latest version of sql?

1031