title: Teradata SQL query limit rows
body: <p>I have a query that return 2 million rows. </p>
  
  <pre><code>SELECT 
  * 
  FROM dB.TABLE
  LIMIT .....
  </code></pre>
  
  <p>I want to get 100000 rows trying my first query like get rows 1 to 100000. Then rewrite my query to pull next 100000. There are now column like Counter/Line Number in my table .. what are my options?</p>