Hi,

I try to make a selection with dynamic numberation.

My table looks like this:

Name Street
==== ====
Mark Street1
Mark Street2
Steve Street3
Gena Street4
Gena Street5

The result should look like this:

Name Nr Street
==== == ====
Mark 1 Street1
Mark 2 Street2
Steve 1 Street3
Gena 1 Street4
Gena 2 Street5

I hope someone has an idea how to solve this,
cheers.

Have a look at the RANK() and/or ROW_NUMBER() functions. If you use a partition by "Name", you should get what you want.

Thanks, it worked with rank and row_number