MySQL - generate numbers for groups of a result
Posted
by FreeIX
on Stack Overflow
See other posts from Stack Overflow
or by FreeIX
Published on 2010-06-08T22:28:37Z
Indexed on
2010/06/10
17:42 UTC
Read the original article
Hit count: 134
Filed under:
mysql
I need a query to return this result:
+---------+-----+-------+
| ref_nid | nid | delta |
+---------+-----+-------+
| AA | 97 | 1 |
| BB | 97 | 2 |
| CC | 97 | 3 |
| DD | 98 | 1 |
| EE | 98 | 2 |
| FF | 98 | 3 |
+---------+-----+-------+
However, I do not have the delta column. I need to generate it for each nid group.
In other words, I need an auto incremented number for each group of the result.
© Stack Overflow or respective owner
