title: Netezza Limit clause with order by
body: <p>In Netezza, if I do:</p>
  
  <pre><code>SELECT 
     *
  FROM Tbl order by col1 
  LIMIT 10 OFFSET 20;
  </code></pre>
  
  <p>First of all, what is OFFSET 20. And also, will this give me the first 10 rows specified in the order by or will the order by apply after random 10 rows are selected? I wish to select the first 10 rows of the table as specified in my order by.</p>