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 meant by recursive hints in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What are the ways tablespaces can be managed and how do they differ?
What is oracle in java?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is the difference between substr & instr functions?
What to do if the binary spfile is wrong for the default instance?
How to empty your oracle recycle bin?
How to define a procedure inside another procedure?
How does oracle handle read consistency?
What is oracle sid?
How to select some columns from a table in oracle?
What are the most common interview questions on ETL Testing for experience?
Is oracle an open source?
What is an anonymous block?
