title: MySQL select last 'n' records by date, but sorted oldest to newest
body: <p>I have a table that has transactions with a datetime column.  I'm trying to select the last 'n' records (i.e. 20 rows) but have it sorted oldest to newest.</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE 1=1
  ORDER BY table.datefield DESC
  LIMIT 20;
  </code></pre>
  
  <p>Gives me the 20 most recent, but in the opposite order.  </p>
  
  <p>Is this possible in one query, or will I have to do a query to get total rows and then adjust the limit based on that so I can do the table.datefiled ASC and then limit <em>(total rows - n), n</em></p>