www说
我总是最终遵循这种模式。鉴于此表:+------+------+| i | j |+------+------+| 1 | 11 || 1 | 12 || 1 | 13 || 2 | 21 || 2 | 22 || 2 | 23 || 3 | 31 || 3 | 32 || 3 | 33 || 4 | 14 |+------+------+你可以得到这个结果:+------+------+------------+| i | j | row_number |+------+------+------------+| 1 | 11 | 1 || 1 | 12 | 2 || 1 | 13 | 3 || 2 | 21 | 1 || 2 | 22 | 2 || 2 | 23 | 3 || 3 | 31 | 1 || 3 | 32 | 2 || 3 | 33 | 3 || 4 | 14 | 1 |+------+------+------------+通过运行此查询,不需要定义任何变量:SELECT a.i, a.j, count(*) as row_number FROM test aJOIN test b ON a.i = b.i AND a.j >= b.jGROUP BY a.i, a.j