title: alternative for "row_number() over(partition by"
body: <p>looking for alternative for query below<br>
  Without <code>row_number() over(partition by</code> :</p>
  
  <pre><code>select *,row_number() over(partition by [Tag Name],[PRD] order by [Start Time]) num
  from [PRD Project].[Data].[efan1]
  </code></pre>