title: increment if not same value of column
body: <p>i want to increment order if rank value is not same </p>
  
  <p>i have tried following query</p>
  
  <p><a href="http://sqlfiddle.com/#!2/d9a7d/2" rel="nofollow">SQL FIDDLE</a></p>
  
  <pre><code>select rank, @rownum := @rownum + 1 AS `myorder`
  from myRankorder, (SELECT @rownum := 0) AS a
  order by rank desc 
  </code></pre>
  
  <p>but it return this result</p>
  
  <pre><code>RANK   MYORDER
  10     1
  8      2
  6      3
  6      4
  4      5
  4      6
  4      7
  3      8
  2      9
  1      10
  </code></pre>
  
  <p>Desired Output</p>
  
  <pre><code>RANK   MYORDER
  10     1
  8      2
  6      3
  6      3
  4      4    &lt;-- if rank value is same do not increment myorder value
  4      4
  4      4
  3      5
  2      6
  1      7
  </code></pre>