title: How to calculate Rank from mysql table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3333665/mysql-rank-function">Mysql rank function</a>  </p>
  </blockquote>
  
  
  
  <p>I have the following table in MySQL:</p>
  
  <pre><code>===================================================================
  id  | member|  total_correct_question | time_taken_in_seconds |
  
  ===================================================================
  1   |  abc  |     2                    |       4              |
  2   |  def  |     3                    |       6              |
  3   |  ghi  |     3                    |       4              |
  4   |  jkl  |     3                    |       5              |
  ====================================================================
  </code></pre>
  
  <p>I want to show the rank of each user from mysql query. Can any one suggest me a query for this?</p>