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 the maximum number of triggers that can be applied to a single table?
How to create additional tablespaces for an new database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is oracle server autotrace in oracle?
Explain the use of owner option in exp command.
How many categories of data types?
material view and view disadvantages?
How to handle a single quote in oracle sql?
How to create an oracle testing table?
Is oracle the best database?
What is a static data dictionary in oracle?
How to fetch the row which has the max value for a column?
How to select some columns from a table in oracle?
How can you use check constraints for self referential integrity?