title: ROWNUM equivalent in Teradta
body: <p>is there anything equivalent to "ROWNUM" in teradata ? i have to implement the below query in teradata, it runs fine with oracle. any ideas or suggestions ?</p>
  
  <pre><code>    INSERT INTO ADDRES(CITY,STATEPROVINCEID) SELECT 'sample',AA.ID FROM
      AA WHERE ROWNUM&lt;=1000
  </code></pre>