Find out the 3rd highest salary?

Answer Posted / tathagoto

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

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Compare sql & pl/sql

612


What is difference between my sql and sql?

531


How delete a row in sql?

535


What are different methods to trace the pl/sql code?

544


What sql does db2 use?

544






What is the difference between nested table and varray?

523


Does sqlite need a server?

541


What are all the different normalizations?

590


Is it possible to read/write files to-and-from PL/SQL?

655


What is meant by cursor in sql?

548


What is raw datatype in sql?

558


What is sql injection vulnerability?

494


What is lexical units in pl sql?

573


What are some emotional triggers?

571


What is a database event trigger?

597