Hey Dave,

I have a followup question.

How to create a parent group and subgroup of data still using with row_number() over() function.

The use of parent group is to group the child/sub...

Thanks Dave,

Simple but good solution. Now I need to do a manuever to this thing to make an exact set of numbers by 50.

By the way thanks again.

Hi Gardin,

Thanks for the reply.

Your answer is nice, but I think it's more complicated and messy.

As I mentioned the value recieved by the parameter is dynamic so we can't expect...