When “Top N” and “After Record” are both set, which one wins?

Short answer: neither “wins” — they’re merged.

Behind the scenes, Select Records doesn’t treat these options as mutually exclusive.
It normalizes everything into row ranges and applies them together.

So:

  • Top N = 10

  • After Record = 50

Does not mean “top 10 after row 50”.

It means:

  • Rows 1–10

  • plus rows 51–end

This design allows disjoint row selection in a single pass.

Why this matters
Users sometimes expect execution order. The node applies set logic, not sequencing.