Skip to main content

Gt

Greater-than comparison (left > right). Extends CompOperator. Shorthand keys: >, gt.

Constructor​

Gt(left: string | SqlElement, right?: any): Gt
new Gt(left: string | SqlElement, right?: any): Gt

Dual-callable. left can be a field-name string (optionally with a trailing []) or an SQL element; right can be a literal, Param, Raw, or sub-Select.

import { Gt, Select } from '@sqb/builder';

Select().from('customers').where(Gt('age', 18));
// where age > 18

Properties​

Inherits every property from CompOperator (_type, _left, _right, _symbol, _isArray); _symbol is always '>'.

Methods​

Inherits ._serialize() from CompOperator; Gt adds no methods of its own.

Object-literal shorthand​

Select().from('customers').where({ 'age >': 18, 'price gt': 100 });
// where age > 18 and price > 100

See also​