Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramesh.ch
select max(salary) from emp
where salary< ( select max(salary) from emp)
explanation::
first sub query returns maximum salary of employee
than main query returns maximum salary lessthan the maximum
salary return by subquery
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a schema in oracle?
Explain about your project and its relation to the current job position you are applying to?
Explain an index?
What are the general rules on data consistency?
What are the ways tablespaces can be managed and how do they differ?
Is oracle a language?
What is an oracle function?
What are joins, explain all types of joins?
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 to compare dates in oracle sql?
What do you understand by database schema and what does it hold?
How to create lov dynamically at runtime & attach to text field?
How do I uninstall oracle 11g?
How to unlock the sample user account in oracle?
What is the difference between alert log file and tarce file ?
