Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

number similar entries in a sequence

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 10, absolute service time: 0,19 sec, absolute service time: 0,18 sec 
edit mode |  history
   i id value seq
1 1 1 1 1
2 2 1 0 1
3 3 1 0 2
4 4 1 1 1
5 5 1 1 2
6 6 1 1 3
7 7 2 0 1
8 8 2 1 1
9 9 2 0 1
10 10 2 0 2