 <p>Select them using <code>limit</code> and <code>offset</code>:</p> <pre><code>SELECT * FROM table ORDER BY cpc DESC LIMIT 1 OFFSET 0; </code></pre> <p>Then:</p> <pre><code>LIMIT 1 OFFSET 1 LIMIT 1 OFFSET 2 </code></pre> <p>and so on.</p>