title: rownum equivlent in teradata
body: <p>How to convert rownum in following query(oracle) to teradata equivalent:</p>
  
  <pre><code>and not exists(select 1
     from CSE, SPD 
     WHERE cse.id=spd.id
     AND ROWNUM = 1
     AND CSE.STATUSID IN(6,7,8,13)
  </code></pre>
  
  <p>thanks.</p>