Class: WindowSpecBuilder
Defined in: src/query/WindowFunction.ts:3
Constructors
Constructor
new WindowSpecBuilder():
WindowSpecBuilder
Returns
WindowSpecBuilder
Methods
partitionBy()
partitionBy(...
columns):this
Defined in: src/query/WindowFunction.ts:8
Parameters
| Parameter | Type |
|---|---|
...columns | string[] |
Returns
this
orderBy()
orderBy(
column,direction?):this
Defined in: src/query/WindowFunction.ts:13
Parameters
| Parameter | Type | Default value |
|---|---|---|
column | string | undefined |
direction | "ASC" | "DESC" | 'ASC' |
Returns
this
orderByDescending()
orderByDescending(
column):this
Defined in: src/query/WindowFunction.ts:18
Parameters
| Parameter | Type |
|---|---|
column | string |
Returns
this
rowsBetween()
rowsBetween(
start,end):this
Defined in: src/query/WindowFunction.ts:22
Parameters
| Parameter | Type |
|---|---|
start | string |
end | string |
Returns
this
toSql()
toSql(
adapter?):string
Defined in: src/query/WindowFunction.ts:27
Parameters
| Parameter | Type |
|---|---|
adapter? | IDbAdapter |
Returns
string