title: SQL SERVER 2012: Subtract elements in a single column
body: <p>Is there an easy way in SQL Server 2012 to subtract the n+1 - n value in a column?</p>
  
  <p>I.e. suppose I have data like this.</p>
  
  <pre><code>    name value
      matt 25
      val  100
      hal  75
      brit 0
  </code></pre>
  
  <p>I want to get a result like this</p>
  
  <pre><code>    name value subtract
      matt 25    25
      val  100   75
      hal  75   -25
      brit 0    -75
  </code></pre>