how can we add a column in table, for count total row in table.

See more:

SQL-Server

I have a table:

tbl_1 :
 
TypeID    Product        
 
9        ELectronic                 
8         Health                                                
5        Cloth            
2        Health                                                
1        Cloth            

Now I want to add a column which shows total count in sequence order as:

TypeID    Product       Total  
 
9        ELectronic      1            
8         Health         2                                       
5        Cloth           3 
2        Health          4                                      
1        Cloth           5

Above table has 5 row, so it add count in sequence order(1-5, as per row count) in another column (as Total).

Any suggetion really appreciate !