SQLite Forum

Row count
Login
I have the following data

IDX 	DATA
1 	a
2 	a
3 	a
4 	b
5 	b
6 	b
7 	b
8 	b
9 	c
10 	c

How can I get the row count as such

IDX 	DATA 	COUNT
1 	a 	1 / 3
2 	a 	2 / 3
3 	a 	3 / 3
4 	b 	1 / 5
5 	b 	2 / 5
6 	b 	3 / 5
7 	b 	4 / 5
8 	b 	5 / 5
9 	c 	1 / 2
10 	c 	2 / 2

Thanks for your help