select sal from (select sal from salary order by sal desc) where rownum &

Find out the 3rd highest salary?

Question Posted / tathagoto

Answer Posted / tathagoto

select sal from (select sal from salary order by sal desc)
where rownum <4;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is sap sql?

536

what are the features and advantages of object-oriented programming? : Sql dba

549

Which is faster subquery or join?

662

Explain the update statement in sql

562

What is keys and its types?

546

What is bind reference and how can it be created?

581

Define tables and fields in a database

646

What are database links used for?

595

Which one is better subquery or joins?

557

What is nosql db?

546

how to enter binary numbers in sql statements? : Sql dba

493

Does execute immediate commit?

700

What is the difference between inner join and natural join?

513

What are the qualities of 2nf?

546

What is pragma in pl sql?

601