How do I select each data set from a Row_Number Over Partition by table based on the Row_Number Over Partition by column?
<p>How do I select each data set from a Row_Number Over Partition by table based on the Row_Number Over Partition by column? </p>

<p>please diagram below:</p>

<pre><code>+-----------+-------------+-------------------+------------+----------+
| packageid | packagename | package max units | references | row_Numb |
+-----------+-------------+-------------------+------------+----------+
|     44    | Basic       | 10                | 103        | 1        |
|     45    | Basic       | 10                | 103        | 2        |
|     42    | Cola        | 10                | 102        | 1        |
|     43    | Cola        | 10                | 102        | 2        |
|     46    | Cola        | 10                | 102        | 3        |
|     2     | Home        | 11                | 101        | 1        |
|     11    | Home        | 11                | 101        | 2        |
|     21    | Home        | 11                | 101        | 3        |
|     1     | Spicy       | 11                | 104        | 1        |
|     3     | Spicy       | 11                | 104        | 2        |
|     41    | Spicy       | 11                | 104        | 3        |
+-----------+-------------+-------------------+------------+----------+
</code></pre>

<p>I want select each data set in each group based on the row_num column.</p>

<p>Every attempt is welcomed.</p>