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 the difference between a hot backup and a cold backup in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is a cursor variable?
What is data type in oracle?
How to run create database statement?
How do I find my oracle client driver version?
What is a connect identifier?
What is the quickest way to fetch the data from a table?
what is the difference between data migration and production migration.
Why should I use oracle database?
Describe varray?
How to change program global area (pga) in oracle?
Explain the use of online redo log files in oracle.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to get a create statement for an existing table?
