title: select records After top 1000 rows
body: <p>I want to select records from 1000 to 2000 rows and so on in batch of 1000.</p>
  
  <p>I have written query to select top 1000 records but how can i select from 1000 to 2000.</p>
  
  <p>can you help me with a query that can select those records.</p>
  
  <pre><code>SELECT TOP 1000 *
  FROM tblProductInformation p1 INNER JOIN tblProduct1 p 
  ON p.productname = p1.productname 
  </code></pre>