title: finding rank of student in table
body: <p>I am new to mysql. I googled  but couldn't find any satisfactory answer.</p>
  
  <p>Basically, I need to provide rank to student . The only thing to be considered is explained in given example.
  Let we have a table student(id,marks,rank).
  Now let the entries be </p>
  
  <pre><code>id    marks
  1      2
  2      2
  3      3
  4      4 
  5      4
  6      3
  7      3
  </code></pre>
  
  <p>Here the ranks of id's : 4 and 5 should be FIRST.<br>
  ranks of id's : 3 , 6  and 7 should be THIRD.<br>
  ranks of id's : 1 and 2 should be SIXTH.<br>
  What should be the query ?</p>