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
How to assign a tablespace to a users in oracle?
How to delete a column in an existing table in oracle?
WHAT IS ecc 6.0
How to rename a tablespace in oracle?
When do you get a .pll extension in oracle?
What is the difference between 10g OEM and 11g OEM?
Explain the characteristics of oracle dba?
How to create a new tablespace in oracle?
How to count groups returned with the group by clause in oracle?
What are group functions in oracle?
What happens if you lost a data file?
What is index-organized table in Oracle?
What is raw datatype?
Does oracle partitioning improve performance?
How to return top 5 rows in oracle?