Comments - How to count items for a specific ordernation

6 years, 1 month ago Guilherme Nogueira

This is my table:

PACKAGE_IDITEM_ID
11
12
13
24
25
36
47
48

I want a new column called count that count 1 to N according to package ID. E.g.:

PACKAGE_IDITEM_IDCOUNT
111
122
133
241
252
361
471
482

Thanks!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.