title: Add a sequential number on create / insert - Teradata
body: <p>In oracle we would use rownum on the select as we created this table. Now in teradata, I can't seem to get it to work. There isn't a column that I can sort on and have unique values (lots of duplication) unless I use 3 columns together. </p>
  
  <p>The old way would be something like,</p>
  
  <pre><code>create table temp1 as 
    select
      rownum as insert_num,
      col1,
      col2,
      col3
    from tables a join b on a.id=b.id
  ;
  </code></pre>