title: SQL start ROW_NUMBER() at 0
body: <p>I have this line of code:</p>
  
  <pre><code>ROW_NUMBER() OVER (ORDER BY V_CONSTAT_ACTUAL_DATES.DATE_TO_END) AS SortOrder
  </code></pre>
  
  <p>but this starts at 1..... How do I get it to start at 0?</p>
  
  <p>I've tried <code>ROW_NUMBER() - 1</code> but that didn't work. I also tried <code>1 - ROW_NUMBER()</code> but that gives me 0 then -1.</p>