Hi,

I'm happy that I can help.

The row number help with cause we have a new column to group by. If you'll add the rnum to the outer select you'll see how he effects the query.