ÇóÒ»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 |
|