title: Mysql query to get the row position in a table
body: <p>I have table with id (store user id) and score in different match. I want what is the position of a user.</p>
  
  <p>So for i try this <a href="http://sqlfiddle.com/#!2/5ff3e/25" rel="nofollow noreferrer">sql fiddle</a>;
  in this I am getting all the row but I need only user having id 3 and it position in the table.</p>
  
  <p>like this:</p>
  
  <pre><code>Score  Postion
  26        3
  </code></pre>
  
  <p>Even i try to do like this but no success  </p>
  
  <ol>
  <li><a href="https://stackoverflow.com/questions/16990420/mysql-find-row-number-of-specific-record">MySql: Find row number of specific record</a></li>
  <li><a href="https://stackoverflow.com/questions/3126972/mysql-row-number">With MySQL, how can I generate a column containing the record index in a table?</a></li>
  </ol>