title: Return Asc Increment After Sort MYSQL
body: <p>I want to have asc index number/serial number after order by price. that mean i want the highest amount be the first row, then the serial number for it is 1, and etc.</p>
  
  <pre><code>serial number |  products  |  price
  1                A            10000
  2                C            4000
  3                B            20
  4                D            10
  </code></pre>
  
  <p>i tried these:</p>
  
  <p>//1st trial</p>
  
  <pre><code>select COALESCE((id) + 0, 0) as serial 
  </code></pre>
  
  <p>//2nd trial</p>
  
  <pre><code>SELECT  @s:=@s+1 serial_number,student_id,student_name,student_avg
  FROM    students,
      (SELECT @s:= 0) AS s
  WHERE
  student_avg &gt; 4;
  </code></pre>
  
  <p>both give me serial number not from 1 - n, it's messed up. </p>
  
  <p>FYI: im using laravel 4.2</p>