Egon ORM

Appearance

egon-orm-workspace / egon-orm / ntile

Function: ntile() ​

ts
function ntile<N>(buckets): WindowFunction<number, ParamsOf<N>>;

Defined in: core/src/query/advanced/windows.ts:321

ntile(buckets): which of buckets nearly equal groups the current row falls in, from

  1. Needs .over(…).

Type Parameters ​

N ​

N extends number | Expr<number | null, never>

Parameters ​

buckets ​

N

Returns ​

WindowFunction<number, ParamsOf<N>>

Example ​

ts
ntile(4).over({ orderBy: [p.views] });

Throws ​

QueryError when buckets is not a whole number of at least 1 or an expression.