title: create primary key ROW_NUMBER() over function sql teradata
body: <p>I want to create a primary key in my <code>select</code> statement. I read that I can use <code>ROW_NUMBER() over</code> function. But as it is going to be primary key, i don't have any columns for <code>over</code> or <code>partition by</code>. I tried using just <code>select row_number() as PK</code>but that throws error <code>[3706] syntax error: expected something between ( and as keyword</code>.</p>
  
  <p>how could I resolve the issue?</p>