Return to Answer

added 124 characters in body

Source Link

edited Jan 26, 2023 at 6:42

You can create a Virtual LayerVirtual Layer. Replace "color" with the name of your color field and 'Random points' with the name of your layer:

select  *, 
        row_number() over(partition by "color") as "SERIAL"
from 'Random points'

A new temporary layer will be created which you can right click and save:

You can create a Virtual Layer. Replace "color" with the name of your color field and 'Random points' with the name of your layer:

select  *, 
        row_number() over(partition by "color") as "SERIAL"
from 'Random points'

A new temporary layer will be created which you can right click and save:

You can create a Virtual Layer. Replace "color" with the name of your color field and 'Random points' with the name of your layer:

select  *, 
        row_number() over(partition by "color") as "SERIAL"
from 'Random points'

A new temporary layer will be created which you can right click and save:

Source Link

created Jan 26, 2023 at 6:13

You can create a Virtual Layer. Replace "color" with the name of your color field and 'Random points' with the name of your layer:

select  *, 
        row_number() over(partition by "color") as "SERIAL"
from 'Random points'

A new temporary layer will be created which you can right click and save: