SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query With analytical function

515746Aug 10 2010 — edited Nov 6 2010

Hi

Below is the scenario which i am looking for in sql query using analytical functions

I/p

Col1 
50
0
-150
-200
300
-100
-300
500
-100


O/p 

Col1     	col2
50            	0
0              	0
-150          -100
-200         	-200
300          	0
-100         	0
-300         	-100
500          	400
-100         	0

Any help really appreciated

Thanks in advance

Edited by: unique on Aug 10, 2010 4:53 AM

Edited by: unique on Aug 10, 2010 4:55 AM

Edited by: unique on Aug 10, 2010 4:55 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2010

Added on Aug 10 2010

6 comments

1,321 views