title: Teradata - limiting the results using TOP
body: <p>I am trying to fetch a huge set of records from Teradata using JDBC. And I need to break this set into parts for which I'm using "Top N" clause in select.
  But I dont know how to set the "Offset" like how we do in <strong>MySQL</strong> -</p>
  
  <pre><code>   SELECT * FROM tbl LIMIT 5,10
  </code></pre>
  
  <p>so that next select statement would fetch me the records from (N+1)th position.</p>