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
Which is faster join or subquery in oracle?
Give the constructs of a package, function or a procedure.
Can objects of the same schema reside in different tablespace?
How to connect asp pages to oracle servers?
How to call a stored function with parameters?
What operating systems are supported by oracle database 10g xe?
What is flashback in Oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to define a cusotmer as a supplier in ORACLE R12
What is the fastest query method to fetch data from the table?
How to grant create session privilege to a user in oracle?
How many categories of data types in oracle?
How to get maxsal , minsal, ename department wise in single query
what is meant by magic query
