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
How data locks are respected in oracle?
How do I call oracle stored procedures that take no parameters?
Is oracle an operator?
How to list all indexes in your schema?
What privilege is needed for a user to query tables in another schema?
what are steps for interface? where is exchange rate defined in which table?
What is analyze command used for?
What is recovery manager in Oracle?
How do I find the database name in oracle?
How to use group functions in the select clause using oracle?
Explain parameter file in oracle.
what are bitmap indexes? How does they work?
What is an oracle database?
Can you assign multiple query result rows to a variable?
What is index in Oracle?