title: MySQL ORDER BY Twice (by same field)
body: <p>I have a series of events with dates, as follows:</p>
  
  <ul>
  <li>Event 1, 1/1/2014</li>
  <li>Event 2, 1/2/2014</li>
  <li>Event 3, 1/3/2014</li>
  </ul>
  
  <p>Say I wanted the most recent two events, in chronological order. If I ran:</p>
  
  <p><code>SELECT * FROM 'table_name' ORDER BY 'Date' ASC LIMIT 2</code></p>
  
  <p>I would get the following results:</p>
  
  <ul>
  <li>Event 1, 1/1/2014</li>
  <li>Event 2, 1/2/2014</li>
  </ul>
  
  <p>But this is incorrect, as Event 3 is the most recent event. So I therefore change ASC to DESC:</p>
  
  <p><code>SELECT * FROM 'table_name' ORDER BY 'Date' DESC LIMIT 2</code></p>
  
  <p>And I get the following results:</p>
  
  <ul>
  <li>Event 3, 1/3/2014</li>
  <li>Event 2, 1/2/2014</li>
  </ul>
  
  <p>This is the correct result set, but they're backwards. I would like the most recent event last...but I can't simply use <code>ORDER BY 'Date'</code> a second time. Is there a way to limit my results (via a <code>LIMIT</code> and an <code>ORDER BY</code>, and then use a second <code>ORDER BY</code>on the remaining results?</p>
  
  <p>Any help is much appreciated!</p>