title: Determine the rank of each row in a sorted table
body: <p>Let's say I have this table:</p>
  
  <pre><code>ID Score
  1   345
  2   5
  3   76
  4   45
  5   85
  6   175
  7   209
  </code></pre>
  
  <p>and this is my query:</p>
  
  <pre><code>SELECT * FROM posts ORDER BY Score DESC
  </code></pre>
  
  <p>How do I get the rank/position of <strong>each</strong> row?</p>