title: Mysql Query to create serial number in the result and where condition apply for that serial number
body: <p>I need a query which results a serial number and also a where condition to filter that serial number like "where serial_number between 0 to 10"</p>
  
  <pre><code>Select  @rown:=@rown+1 serial_number, user_name as un from user
                              (select @rown := 0) as t
                              where                 
                               (@rown := (@rown + 1)) between 0 and 10
                              ORDER BY u.id_user asc
  </code></pre>
  
  <p>but i didnt get the result in between,
  kindly help me</p>