Answer Posted / murali
select level,max(sal) from emp where level=&levelno connect by prior sal>sal group by level;
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What do you know by pl/sql cursors?
How exception handling is done in advance pl/sql?
How do I count records in sql?
What is scope and visibility in PL/SQL?
Can we alter stored procedure?
What is a pragma statement?
Can you join a table to itself?
how would you enter characters as hex numbers? : Sql dba
Why stored procedures are faster than query?
What is cursor in pl sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the difference between row level and statement level trigger?
what is unique key constraint? : Sql dba
what is the different between now() and current_date()? : Sql dba
Explain the purpose of %type and %rowtype data types with the example?