title: Assigning unique ROW NUMBER() for all the PARTITIONED RECORDS
body: <p>In this query it is partitioning the records but i need to assign row number for all the result set a row number should not be repeated it should be unique fpr each row.Anyone help ? Thanks in advance.</p>
  
  <pre><code>select *
  from Store  
  order by 
     row_number() over (partition by category order by storename),category
  </code></pre>
  
  <p>Table cloumn sample in SQLFIDDLE :
  <a href="http://sqlfiddle.com/#!6/767ab/86" rel="nofollow">http://sqlfiddle.com/#!6/767ab/86</a></p>
  
  <p>I want output in the format of :</p>
  
  <pre><code>RowNo     Category  
  1         Fruits
  2         Chocs
  3         Vegetables
  4         Fruits
  5         Chocs
  6         Vegetables
  ..........
  </code></pre>