find out the third highest salary?
Answer Posted / lakshmi
select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));
| Is This Answer Correct ? | 94 Yes | 135 No |
Post New Answer View All Answers
How to recover a dropped table in oracle?
What is a server parameter file in oracle?
Which environment variables are absolutely critical in order to run the OUI?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
In the oracle version 9.3.0.5.0, what does each number shows?
How can I get column names from a table in oracle?
How to update values on multiple rows in oracle?
What are the different pseudo commands? Explain in general?
Explain the features of oracle?
Explain the use of record option in exp command.
What happens to the indexes if a table is recovered?
Can we commit inside a function in oracle?
How many types of synonyms in Oracle?
How to write a query with an inner join in oracle?
What is the difference between hot backup and cold backup in oracle?