find out the third highest salary?

Answer Posted / biswapratap singh

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal DESC)

Is This Answer Correct ?    214 Yes 73 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a select query statement in oracle?

543


What are temporal data types in oracle?

596


What is bulk copy or bcp in oracle?

606


What is Virtual Private Database in Oracle?

618


What is ASM (Automatic Storage Management) in Oracle?

710






How to load data through external tables?

581


What is tns entry?

621


Difference between varchar and varchar2 data types?

660


How can Oracle users be audited?

601


How many memory layers are in the oracle shared pool?

637


What do you mean by redo log file mirroring?

553


How to create an oracle database manually?

568


What is oracle in java?

524


What are a cluster and non-cluster index?

572


what is the scripts in data base?

1600