I ran this script it in sql2000. it is working fine. it shows 1,2,3,4,5,6. so the correct answer is c.