While going through sql columns, if we find duplicate values then we need incrementing a count starting with 1. 

Any Value that matches the original value found in column "Filenum".

**It should look like this on the output.**

```
-------------------------------
| FILENUM coulmn | num column | 
| a              |          1 |
| a              |          2 |
| a              |          3 |
| b              |          1 |
| b              |          2 |
| c              |          1 |
| d              |          1 |
| a              |          4 |
| b              |          3 | 
-------------------------------

```

Any solution that you can suggest..It will be even better if funcions like row\_number() can be avoided..Thanks in adv