test=# create temp sequence test_seq;
CREATE SEQUENCE
test=# select nextval('test_seq'), name from test;
nextval | name
---------+------------
1 | name text
2 | zms text
3 | smz text
4 | name text
5 | zms text
6 | smz text
7 | name text
8 | zms text
9 | smz text
你可以
mysql> select * from b;
+-------+------+
| test | full |
+-------+------+
| test1 | 50 |
| test2 | 70 |
| test3 | 100 |
+-------+------+
3 rows in set (0.00 sec)
mysql> select count(*) as rownum,b.* from b left join b bb on b.test>=bb.test g
roup by b.test;
+--------+-------+------+
| rownum | test | full |
+--------+-------+------+
| 1 | test1 | 50 |
| 2 | test2 | 70 |
| 3 | test3 | 100 |
+--------+-------+------+
3 rows in set (0.00 sec)