Takes rows by their numbers, for a database whose engine plan can't take
them right (PLAN §11.4): <input>->extend([<keys>]->over(), ~[cube_rn: {p, w, r | $p->rowNumber($r)}])->filter({row | <range>})->select(~[<input columns>]).
The rows are numbered from 1 in the input's order, else by the first input
column that sorts, ascending; range gets the row number to compare. No
sort is written before it: in a derived table, SQL Server rejects one. It
gives undefined when no column sorts, for the native form.
Takes rows by their numbers, for a database whose engine plan can't take them right (PLAN §11.4):
<input>->extend([<keys>]->over(), ~[cube_rn: {p, w, r | $p->rowNumber($r)}])->filter({row | <range>})->select(~[<input columns>]). The rows are numbered from 1 in the input's order, else by the first input column that sorts, ascending;rangegets the row number to compare. No sort is written before it: in a derived table, SQL Server rejects one. It givesundefinedwhen no column sorts, for the native form.