I need help with a Running Count Query.
Lets say i have one column,



X
X
X
T
T
E
E
E
E
E

i want to make a query that adds a running count column, like the one below

X ,1
X ,2
X ,3
T ,1
T ,2
E ,1
E ,2
E ,3
E ,4
E ,5

Does anyone know how to do this? any help is GREATLY appreciated.