Split rows into balanced buckets

NTILE divides an ordered sequence into groups with row counts as balanced as possible. This can divide work or a sample, but does not create equal amount ranges or keep equal amounts together.

NTILE(n) numbers buckets from 1 in window order. Bucket sizes differ by at most one row. When division leaves a remainder, larger buckets come first; an id tie-breaker determines placement among equal values.

Split rows into balanced buckets: NTILE(n) numbers buckets from 1 in window order. Bucket sizes differ by at most one row. When division leaves a remainder, larger buckets come first; an id tie-breaker determines placement among equal values.