<p>Some databases support commands such as:</p>

<pre><code>SELECT TOP 10 START AT 10 * FROM &lt;TABLE&gt;
</code></pre>

<p>Essentially I need to pull the first 10 records, then the next 10, then the next 10 etc.  Maybe there is another way to do this but in the past I've done it like the above for databases that support 'START AT'.</p>

```
```
SELECT Top 10 * 
FROM Table 
WHERE <primary key> Not IN (
    SELECT Top 10 <primaryKey> 
    FROM Table 
    ORDER BY <primary Key> ASC) 
ORDER BY <primary Key> ASC
```
```