find out the third highest salary?
Answer Posted / joel
select sal from emp
where sal<(select max(sal) from emp
where sal in (select sal from emp
where sal < ( select max(sal) from emp)))
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
Explain view?
what is a Nested Loop join?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What are group functions in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What types of joins are used in writing subqueries?
How to define a cusotmer as a supplier in ORACLE R12
What is Java Pool in Oracle?
What does sharding mean?
Why does oracle 9i treat an empty string as null?
What happens to the current transaction if a ddl statement is executed?
How to get execution statistics reports on query statements?
How to get the Installed Oracle Version Information ?
How to assign data of the deleted row to variables?