Answer Posted / venubabu
Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
sql>Enter value for level:5
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why oracle is used?
What to do if the startbd.bat failed to start the xe instance?
How do we display rows from the table without duplicates?
State the difference between a primary key and foreign key?
Can you have more than one content canvas view attached with a window ?
What are the arithmetic operations?
How to use subqueries in the from clause in oracle?
Explain the use of record length option in exp command.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a sub query? What are its various types?
What is the minimum client footprint required to connect c# to an oracle database?
How do I manually create a database in oracle?
What is different types of joins?
How do I know if oracle client is installed on windows?
Differentiate between function and procedure in oracle.