rowNo

rowNo(X)

X is a vector.

Return the index position of each row in a table.

team=1 1 1 1 1 2 2 2 2 2
id=1..5 join 2..6
x=11..20\2
t=table(team, id, x)
t;

select * from t where rowNo(id)%3=0;

update t set teamFirst=(rowNo(id)==0) context by team;
t;