Count of rows for a particular column and display with the last row
<p>I have to count the rows for a same values in a column and display the count value with the last column. Below is my scenario</p>

<p>Table 1  </p>

<pre>Col_A  Col_B   Col_C
a      1       a1
a      2       a2
a      3       a3
a      4       a4
a      5       a5
a      6       a6
b      7       a7
b      8       a8
b      9       a9
b      10      a10
e      7       a11
e      1       a12
e      4       a13</pre>

<p>while displaying the data I should count same value in COL_A and display as shown below </p>

<pre>Col_A  Col_B   Col_C   Col_D
a      1       a1   
a      2       a2   
a      3       a3   
a      4       a4   
a      5       a5   
a      6       a6      6
b      7       a7   
b      8       a8   
b      9       a9   
b      10      a10     4
e      7       a11  
e      1       a12  
e      4       a13     3</pre>

<p>Thanks,</p>