title: Select last 20 rows from SQL ordered ASC
body: <p>Basically my whole question is the title. Not really much to describe. I just want to select the last 20 rows from SQL ordered asc.</p>
  
  <p>This doesn't work as expected</p>
  
  <pre><code>SELECT * FROM chat ORDER BY id ASC LIMIT 20
  </code></pre>
  
  <p>It returns the <strong>first</strong> 20 rows in ascending order, but I want <strong>last</strong> 20 rows in ascending order. </p>
  
  <p>Any help much appreciated.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>What if my sql looks like this? </p>
  
  <pre><code>SELECT username, text, date FROM chat ORDER BY id ASC LIMIT 20
  </code></pre>