find the third highest salary?

Answer Posted / noorulahaq

select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )

Is This Answer Correct ?    26 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the source code of a program?

505


What is AUTH_ID and AUTH_USER in pl/sql ?

1690


Does pl sql work in mysql?

532


Is sql low level language?

574


What types of commands can be executed in sql*plus?

548






What is the file extension for sql database?

515


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

533


Write a query to find the names of users that begin with "um" in sql?

501


What is partition by in sql?

569


What is the difference between python and sql?

519


Can I call a procedure inside a function?

549


What is a recursive join sql?

593


what are the advantages and disadvantages of cascading style sheets? : Sql dba

547


How do I access sql anywhere database?

495


In pl/sql, what is bulk binding, and when/how would it help performance?

529