Class: WindowFunction

Defined in: src/query/WindowFunction.ts:92

Fluent builder for SQL window functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, etc.)

Constructors

Constructor

new WindowFunction(): WindowFunction

Returns

WindowFunction

Methods

rowNumber()

static rowNumber(): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:93

Returns

WindowFunctionExpression

---

rank()

static rank(): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:97

Returns

WindowFunctionExpression

---

denseRank()

static denseRank(): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:101

Returns

WindowFunctionExpression

---

lag()

static lag(column, offset?, defaultVal?): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:105

Parameters

Parameter	Type	Default value
column	string	undefined
offset	number	1
defaultVal?	unknown	undefined

Returns

WindowFunctionExpression

---

lead()

static lead(column, offset?, defaultVal?): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:111

Parameters

Parameter	Type	Default value
column	string	undefined
offset	number	1
defaultVal?	unknown	undefined

Returns

WindowFunctionExpression

---

firstValue()

static firstValue(column): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:117

Parameters

Parameter	Type
column	string

Returns

WindowFunctionExpression

---

lastValue()

static lastValue(column): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:121

Parameters

Parameter	Type
column	string

Returns

WindowFunctionExpression

---

sum()

static sum(column): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:125

Parameters

Parameter	Type
column	string

Returns

WindowFunctionExpression

---

avg()

static avg(column): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:129

Parameters

Parameter	Type
column	string

Returns

WindowFunctionExpression

---

count()

static count(column?): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:133

Parameters

Parameter	Type	Default value
column	string	'*'

Returns

WindowFunctionExpression

---

ntile()

static ntile(buckets): WindowFunctionExpression

Defined in: src/query/WindowFunction.ts:137

Parameters

Parameter	Type
buckets	number

Returns

WindowFunctionExpression