neuralib.sqlp.expr.SqlWindowFunc

class neuralib.sqlp.expr.SqlWindowFunc

Bases: SqlAggregateFunc

__init__(oper, *args)
Parameters:

oper (str)

Methods

__init__(oper, *args)

between(value[, value2])

cast(t)

contains(value)

distinct()

glob(value)

is_not_null()

is_null()

like(value)

not_between(value[, value2])

not_contains(value)

not_like(value)

over([name, order_by, partition_by])

where(*args)

Attributes

oper

args

oper
args
__init__(oper, *args)
Parameters:

oper (str)

between(value, value2=None)
Return type:

SqlCompareOper

cast(t)
Parameters:

t (type)

Return type:

SqlExpr

contains(value)
Parameters:

value (Union[Sequence, SqlStat])

Return type:

SqlCompareOper

distinct()
Return type:

Self

glob(value)
Parameters:

value (str)

Return type:

SqlCompareOper

is_not_null()
Return type:

SqlCompareOper

is_null()
Return type:

SqlCompareOper

like(value)
Parameters:

value (str)

Return type:

SqlCompareOper

not_between(value, value2=None)
Return type:

SqlCompareOper

not_contains(value)
Parameters:

value (Union[Sequence, SqlStat])

Return type:

SqlCompareOper

not_like(value)
Parameters:

value (str)

Return type:

SqlCompareOper

over(name=None, *, order_by=None, partition_by=None)
Parameters:

name (str | None)

Return type:

Self

where(*args)
Parameters:

args (bool | SqlExpr)

Return type:

Self