Answer Posted / yadunandan
select max(sal) from emp where sal<(select max(sal) from
emp)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Where do you use decode and case statements?
What are the predefined tablespaces in a database?
What is java oracle used for?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the parameters that we can pass through a stored procedure?
How to select an oracle system id (sid)?
interview questions with answer for cts
How to create an initialization parameter file?
what is the scripts in data base?
What is the difference between substr & instr functions?
How to create an oracle database?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a nested table and how is it different from a normal table?
What is meant by joins? List out the types of joins.
How to change system global area (sga) in oracle?