row_number over partition by order by

If you want to count something inside a group (something the same as auto_increment from mysql), you can use row_number

  ROW_NUMBER ()
               OVER (PARTITION BY ur_prnt_uid_id ORDER BY ur_chld_uid_id)