<div>
Yes, I believe, however, you should also have a column (or set of columns) to order these rows.
</div>


Yes, I believe, however, you should also have a column (or set of columns) to order these rows.

<div>
Thanks for the solution and a link to create my own sample code. Awesome
</div>


Thanks for the solution and a link to create my own sample code. Awesome

<div>
Thanks for the quick closure, cheers. Paul.
</div>


Thanks for the quick closure, cheers. Paul.

<div>
<div class="content wysiwyg-content">
Is there a way to create sql code for cumulative variance? <br />
<br />
col1 | cum var<br />
21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21 &nbsp; &nbsp; &nbsp;=21+0<br />
-34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-13 &nbsp; &nbsp;=21+(-34)<br />
45 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32 &nbsp; &nbsp; = &nbsp;-13+45<br />
56 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88 &nbsp; &nbsp; = 32 + 56<br />
-78 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; = 88 + (-78)
</div>
</div>


Is there a way to create sql code for cumulative variance? 

col1 | cum var
21                  21      =21+0
-34                  -13    =21+(-34)
45                   32     =  -13+45
56                   88     = 32 + 56
-78                  10     = 88 + (-78)

Is there a way to create code for cumulative variance using sql and not excel spreadsheets?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.