title: SQLite: accumulator (sum) column in a SELECT statement
body: <p>I have a table like this one:</p>
  
  <blockquote>
    <p>SELECT value FROM table;</p>
  </blockquote>
  
  <pre><code>value
  1
  3
  13
  1
  5
  </code></pre>
  
  <p>I would like to add an accumulator column, so that I have this result:</p>
  
  <pre><code>value  accumulated
  1      1
  3      4
  13     17
  1      18
  5      23
  </code></pre>
  
  <p>How can I do this? What's the real name of what I want to do? Thanks</p>