Answer Posted / purushotham
select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
how do you control the max size of a heap table? : Sql dba
How to call shell script from pl sql procedure?
Difference between global and parameter variables?
when is the use of update_statistics command? : Sql dba
what is not null constraint? : Sql dba
Why is the cursor important?
Explian rowid, rownum? What are the psoducolumns we have?
What is clustered and nonclustered index in sql?
What are the steps for performance tuning.
How to revise and re-run the last sql command?
What is pivot query?
What is function and procedure in pl sql?
How do I create an index in word?
Is pl sql better than sql?
How do I run a pl sql procedure in sql developer?
