title: Teradata: how to divide a table by row number?
body: <p>How to divide a table in several parts by row number?
  Condition might look like this:</p>
  
  <pre><code>create table part1 as
  Select * from table
  where row_number between 1 and 1000000
  
  create table part2 as
  Select * from table
  where row_number between 1000001 and 2000000
  </code></pre>
  
  <p>thx</p>