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 literal?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Differentiate between translate and replace?
What is the difference between translate and replace in oracle?
List the various oracle database objects?
What are triggers in oracle?
How to shutdown your 10g xe server?
What is a read only transaction in oracle?
Explain what are the characteristics of data files?
Differentiate between function and procedure in oracle.
How much memory your 10g xe server is using?
What is the usage of merge statement?
What are the numeric comparison operations?
How to open a cursor variable?
How to rename an index in oracle?
