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
What is an oracle user account?
what is a Nested Loop join?
What is the difference between substr & instr functions?
Can multiple cursors being opened at the same time?
How to see the table columns used in an index?
What is the difference between pre-select and pre-query?
How many types of synonyms in Oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the sql query to concatenate column values from multiple rows in oracle?
How to calculate date and time differences in oracle?
Point out the difference between user tables and data dictionary?
What is backup in Oracle?
What is meant by a deadlock situation?
What is not equal to in oracle?
How to resolve the ORA-39133 error in Oracle?