select*from(select rownum rn,sal from(select*from emp order by sal desc))wh

Find out the 3rd highest salary?

Question Posted / kumar

Answer Posted / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why are cursors used?

1078

When are we going to use truncate and delete?

941

How do you update f as m and m as f from the below table testtable?

1814

How can we solve sql error: ora-00904: invalid identifier?

1194

What is synonyms?

1013

What is a left inner join?

969

How to order siblings in oracle hierarchy queries?

1005

What is a table?

978

what are the advantages of mysql in comparison to oracle? : Sql dba

952

Why does sql need a server?

1009

How to display the current date in sql?

1024

Can a table contain multiple foreign key’s?

964

How does a trigger work?

1011

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1000

explain mysql aggregate functions. : Sql dba

958