求一MySql语句

需求：
1    1
2    1
3    2
4    2
5    2
6    3
7    3
8    3
9    3

结果

1    1
2    1
1    2
2    2
3    2
1    3
2    3
3    3
4    3
要求：
能在MySql中运行

---

还有其它数据吗?规则是怎样的?

---

SQL code:
select
(select count(1)+1 from tb where col2=t.col2 and col1<t.col1) as col1,
col2
from
tb t

---

标准SQL基本上都支持的。

SQL code:
mysql> select * from t_GG_wg;
+----+------+
| id | fld |
+----+------+
| 1 | 1 |
| 2 | 1 |
| 3 | 2 |
| 4 | 2 |
| 5 | 2 |
| 6 | 3 |
| 7 | 3 |
| 8 | 3 |
| 9 | 3 |
+----+------+
9 rows in set (0.00 sec)

mysql> select count(*),a.fld
-> from t_GG_wg a ,t_GG_wg b
-> where a.fld=b.fld
-> and a.id>=b.id
-> group by a.id
-> order by a.id;
+----------+------+
| count(*) | fld |
+----------+------+
| 1 | 1 |
|