title: How to add rank based on points in mysql
body: <p>I could use some assistance with this query.</p>
  
  <p>Here's my table:</p>
  
  <pre><code>id      name    point
  1       yogi      5
  2       sasi     10
  3       white     5
  4       black     8
  </code></pre>
  
  <p>My query is:</p>
  
  <pre><code>SELECT * FROM points ORDER BY point DESC
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>id      name    point
   2      sasi      10
   4      black      8
   1      yogi       5
   3      white      5
  </code></pre>
  
  <p>But I'd like results like below. Please guide me.</p>
  
  <pre><code>id      name    point  rank
   2      sasi      10     1
   4      black      8     2
   1      yogi       5     3
   3      white      5     4
  </code></pre>
  
  <p>Is this possible to do?</p>
  
  <p>thanks in advance.</p>