Question

Why we need to change the sequence of the field ? ​

Answer 1

Explanation:

Hi,

I have following data. I have one more column "Sequence". For this column the values would be Increase by 1 when the "Name" field value changes.

S.No Name

1 Mike

2 Mike

3 Carlos

4 Dave

5 Dave

6 Dave

7 Tim

8 Tim

9 Mark

I need the sequence number for this data as follows like when the "Name" field value change, the Sequence should increase by 1. How can i get this?

S.No Name Sequence

1 Mike 1

2 Mike 1

3 Carlos 2

4 Dave 3

5 Dave 3

6 Dave 3

7 Tim 4

8 Tim 4

9 Mark 5