title: SQL row value ranked as ordinal
body: <p>I have a table like this:</p>
  
  <pre><code>╔═══════════════════════╗
  ║ id   name       spent ║
  ╠═══════════════════════╣
  ║ 1    John       1000  ║
  ║ 2    Bob        2000  ║
  ║ 3    Richard    5000  ║
  ║ 4    Jane       2000  ║
  ║ 5    Anthony    2500  ║
  ╚═══════════════════════╝
  </code></pre>
  
  <p>I'd like to retrieve a row and rank the spent column like this</p>
  
  <pre><code>SELECT name, 
         spent 
  FROM   table 
  WHERE  id = 5 ;
  </code></pre>
  
  <p>and the desired result be something like this:</p>
  
  <pre><code>╔══════════════════════╗
  ║   name       spent   ║
  ╠══════════════════════╣
  ║ Anthony   2500 (2nd) ║
  ╚══════════════════════╝
  </code></pre>
  
  <p>That is, Anthony is the second who spent most (after Richard's 5000)
  and if I wanted to order by who spent less it would be something like this</p>
  
  <pre><code>╔══════════════════════╗
  ║   name       spent   ║
  ╠══════════════════════╣
  ║ Anthony   2500 (4th) ║
  ╚══════════════════════╝
  </code></pre>