Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20413 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
a query to select maxmun 3 salaries of employee table..
a query to select maxmun 3 salaries of employee table..
Answer / neo devan
select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 4 No |
More Oracle General Interview Questions
How to create a new oracle data file?
What is query image?
How to write a left outer join with the where clause in oracle?
does the query needs a hint to access a materialized view?
What is a cursor in oracle?
What is flashback Query ? And Use ?
What is Partitions in Table ?
What is a materialised view?
who is the father of oracle and send chodd rules
What are the factors causing the reparsing of SQL statements in SGA?
Where is the export dump file located?
How to do a full database export?
Oracle General 
