How to make a request with pagination if there is a hasMany link?

Question

Oracle

In Oracle, you need to think of a query that would give the following result:

ID	RN wrong: row_number() over ( partition by id order by id )	RN needs:
one	one	one
one	2	one
one	3	one
5	one	2
5	2	2
eight	one	3
eight	2	3
12	2	4

How can this be done and is it possible at all?

Answer 1

What you probably want is a subquery grouped by id and row_number() and then a join to the original table.