Think of it this way , if u walk into a room and ask each person if they are above 20 years of age, ur are performing something like RBAR or row by row operation. on the other hand if you shouted "everybody over 20 please raise your hand" you dealing with a set. The idea here is to ignore the uniqueness for each row and try to identify what they have in common and use the commonality to programmer better.