title: How can I get a list showing the subtraction result between current Row ID and Previous Row's ID?
body: <p>How can I get a list of IDs in MS SQL table with a number showing the difference between the current row's ID and the previous row's ID -assuming that I have 'ORDER BY ID DESC'</p>
  
  <pre><code>SELECT ID, ???? AS [CurrentID - PreviousID]
  FROM foo
  ORDER BY foo.ID DESC
  </code></pre>