title: MySQL limit from descending order
body: <p>Is it available to write a query to use same "LIMIT (from), (count)", but get result in backwards?</p>
  
  <p>In example if I have 8 rows in the table and I want to get 5 rows in two steps I would:
  first step query:</p>
  
  <pre><code>select * from table limit 0, 5
  </code></pre>
  
  <p>first step result:</p>
  
  <pre><code>first 5 rows;
  </code></pre>
  
  <p>second step query:</p>
  
  <pre><code>select * from table limit 5, 5
  </code></pre>
  
  <p>second step result:</p>
  
  <pre><code>last 3 rows;
  </code></pre>
  
  <p>But I want to get it vice versa. I mean from the first step I want <strong>last 3 rows</strong> and from the second I want <strong>5 first rows</strong>. Thank you for your answer</p>