i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
Answer Posted / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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?
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.
How to best split csv strings in oracle 9i?
How to drop a stored procedure in oracle?
what is the dual table in oracle?
How to list all user accounts in oracle?
How to rebuild an index in oracle?
How can we force the database to use the user specified rollback segment?
Can I create users through internet explorer in oracle 10g?
What is a connect identifier?
What are the differences between interval year to month and interval day to second?
How to create lov dynamically at runtime & attach to text field?
Write a trigger example in oracle?
Explain the use of rows option in imp command.
can u plz provide me oca sql dumps please i need them