Learn about Location2 (first row or all rows)

To retrieve only the first row that matches the criteria of a SELECT query, set Location2 to 0. To retrieve all rows that match the query criteria, set Location2 to 1.

For tag groups, the tag, which executes the query (primary tag), sets this option for all the tags in its group; it is not possible to read only the first record for one group tag member and all records for another group tag member. For tag distribution, the interface always examines the whole result set, regardless of the Location2 setting.