title: Select Top N Records Ordered by X, But Have Results in Reverse Order
body: <p>I'm trying to get the top N records (when ordered by some column X), but have the result set in reverse order. The following statement is <strong>incorrect</strong>, but probably demonstrates what I'm after:</p>
  
  <pre><code>SELECT * FROM (SELECT TOP 10 * FROM FooTable ORDER BY X DESC) ORDER BY X ASC
  </code></pre>
  
  <p>For example, column X could be an ID or a timestamp; I want the latest 10 records but want them returned in forward chronological order.</p>