Yes, recursive CTE is also row by row. When you are not joined any tables then recursive CTE will restrict upto 100 rows.