我想为从表中获取的记录分配一个计数器。
计数器应根据它们所属的组进行分配。
例如
表格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/

10-12 12:46
查看更多