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
What is a select query statement in oracle?
What are temporal data types in oracle?
What is bulk copy or bcp in oracle?
What is Virtual Private Database in Oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to load data through external tables?
What is tns entry?
Difference between varchar and varchar2 data types?
How can Oracle users be audited?
How many memory layers are in the oracle shared pool?
What do you mean by redo log file mirroring?
How to create an oracle database manually?
What is oracle in java?
What are a cluster and non-cluster index?
what is the scripts in data base?