MySQL - generate numbers for a group of results
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/08
22:32 UTC
Read the original article
Hit count: 199
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
