title: How to select last N records from a table in mysql
body: <p>This code can be used to select the first ten records from a table in mysql. How can I do the same to display last ten records from a table which has 1000 records. I want to display the name in asc order dont want to change that.</p>
  
  <pre><code>   SELECT name, cost FROM test orderby name asc LIMIT 10 ;
  </code></pre>