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 to load excel data sheet to oracle database
How many types of synonyms in Oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain the features of oracle?
Explain temporal data types in oracle
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to insert a new row into a table in oracle?
Name the three major set of files on disk that compose a database in Oracle?
Why should I use oracle database?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What are the different types of trigger and explain its various uses and functions?
What is a subquery in oracle?
How to turn on or off recycle bin for the instance?
Differentiate between post-database commit and post-form commit?
What are the logical operations?