Is it possible to add rows to a SQL query's result, similar to the COMPUTE command in SQL*Plus?
That is, for example, when the value for column A changes, add a row after the previous row (the last one before column A changed) to show the sum of the values of column B.
e.g.
<PRE>A B
- --
1 3
1 4
1 5
12
2 9
2 -1
2 -7
1</PRE>