rowNumber function

Expr<int> rowNumber({
  1. List<Expr<Object?>> partitionBy = const [],
  2. List<OrderTerm> orderBy = const [],
})

Builds a one-based SQL row number within each partition.

Supply orderBy for deterministic numbering; this does not order the final query result unless that query also declares its own ordering.

Implementation

Expr<int> rowNumber({
  List<Expr<Object?>> partitionBy = const [],
  List<OrderTerm> orderBy = const [],
}) => Expr.internal(
  WindowNode(
    FunctionNode('ROW_NUMBER', const []),
    List.unmodifiable(partitionBy),
    List.unmodifiable(orderBy),
    null,
  ),
  Codecs.integer,
);