Class: AggregateExpression<R>

Defined in: src/query/GroupedQueryBuilder.ts:48

Type Parameters

Type Parameter	Default type
R	number

Constructors

Constructor

new AggregateExpression<R>(func, column): AggregateExpression<R>

Defined in: src/query/GroupedQueryBuilder.ts:51

Parameters

Parameter	Type
func	"SUM" | "AVG" | "MIN" | "MAX" | "COUNT"
column	string

Returns

AggregateExpression<R>

Methods

toSql()

toSql(adapter): string

Defined in: src/query/GroupedQueryBuilder.ts:56

Parameters

Parameter	Type
adapter	IDbAdapter

Returns

string

---

greaterThan()

greaterThan(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:66

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

greaterThanOrEqual()

greaterThanOrEqual(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:70

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

lessThan()

lessThan(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:74

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

lessThanOrEqual()

lessThanOrEqual(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:78

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

equals()

equals(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:82

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

notEquals()

notEquals(val): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:86

Parameters

Parameter	Type
val	unknown

Returns

HavingCondition

---

between()

between(val1, val2): HavingCondition

Defined in: src/query/GroupedQueryBuilder.ts:90

Parameters

Parameter	Type
val1	unknown
val2	unknown

Returns

HavingCondition

Properties

_resultType

readonly _resultType: R

Defined in: src/query/GroupedQueryBuilder.ts:49

---

func

readonly func: "SUM" | "AVG" | "MIN" | "MAX" | "COUNT"

Defined in: src/query/GroupedQueryBuilder.ts:52

---

column

readonly column: string

Defined in: src/query/GroupedQueryBuilder.ts:53