The FOR EACH RECORD IN ORDER BY statement retrieves and loops only on the first occurrence of a field in a record

The FOR EACH RECORD IN ORDER BY statement loops only on the first occurrence of a field in a record

The FOR EACH RECORD IN ORDER BY statement retrieves and loops on all the occurrence of a field in a record

The FOR EACH RECORD IN ORDER BY statement retrieves and loops on only the last occurrence of a field in a record