title: Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
body: <p>Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?</p>
  
  <p>The LIMIT keyword limits the number of rows returned by a SELECT e.g:</p>
  
  <pre><code>SELECT * FROM People WHERE Age &gt; 18 LIMIT 2;
  </code></pre>
  
  <p>returns 2 rows.</p>
  
  <pre><code>SELECT * FROM People WHERE Age &gt; 18 LIMIT 10, 2;
  </code></pre>
  
  <p>returns 2 rows after the first 10.</p>