我想为从表中获取的记录分配一个计数器。
计数器应根据它们所属的组进行分配。
例如
表格1
|Groups | Counter |Description
-------------------------------------------
|Stationary | 1 | Pen
|Stationary | 2 | Eraser
|Stationary | 3 | Book
|Stationary | 4 | Rule
|Cars | 1 | Benz
|Cars | 2 | Opel
|Cars | 3 | Toyota
最佳答案
你可以试试这个:)
SELECT *, (SELECT COUNT(*)+1
FROM [sometbl] counter
WHERE t.groups = counter.groups
AND t.description > counter.description) AS Counter
FROM [sometbl] t
DEMO
关于mysql - 显示时自动计数,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/22871973/