WindowFunctionDefinition
Represents an SQL window function with window definition.
Properties
Functions
Returns the result of performing a logical and
operation between this expression and the op.
Returns the result of performing a logical and
operation between this expression and the negate op.
Specifies a conversion from one data type to another.
Returns the length of this string expression, measured in characters, or null
if this expression is null.
Returns the number of input rows for which the value of this expression is not null.
Checks if this expression is equal to some t value.
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression.
Checks if this expression is equals to single value returned from query.
Returns value evaluated at the row that is the first row of the window frame.
Calls a custom SQL function with the specified functionName and passes this expression as its only argument.
Checks if this expression is greater than some t value.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than some other expression.
Checks if this expression is greater than or equal to some t value
Checks if this expression is greater than or equal to some other expression.
Checks if this expression is greater than or equal to some other expression
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.GROUPS mode and specified start bound.
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.GROUPS mode and specified start and end bounds.
Checks if this expression is equal to any element from list.
Checks if this expression is equals to any row returned from query.
Checks if this expression is not equal to some t value, with null
treated as a comparable value
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression, with null
treated as a comparable value
Checks if this expression is equal to some t value, with null
treated as a comparable value
Checks if this expression is equal to some other expression.
Checks if this expression is equal to some other expression, with null
treated as a comparable value
Returns true
if this string expression is null or empty, false
otherwise.
Returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead returns defaultValue. Both offset and defaultValue are evaluated with respect to the current row.
Checks if this expression is less than some t value.
Checks if this expression is less than some other expression.
Checks if this expression is less than some other expression.
Checks if this expression is less than or equal to some t value
Checks if this expression is less than or equal to some other expression.
Checks if this expression is less than or equal to some other expression
Checks if this expression matches the specified pattern.
Checks if this expression matches the specified expression.
Checks if this expression matches the specified pattern.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.
Checks if this expression is not equal to some other value.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equal to some other expression.
Checks if this expression is not equals to single value returned from query.
Checks if this expression is not equal to any element from list.
Checks if this expression is not equals to any row returned from query.
Checks if this expression is not equal to any element from the column of table with only a single column.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified pattern.
Checks if this expression doesn't match the specified expression.
Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); null if no such row.
Returns the result of performing a logical or
operation between this expression and the op.
Defines sorting order by column and order pairs order in which the rows of a partition are processed by the window function.
Returns the result of performing a logical or
operation between this expression and the negate op.
Groups the rows of the query by specified expressions into partitions, which are processed separately by the window function.
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.RANGE mode and specified start bound.
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.RANGE mode and specified start and end bounds.
Calculates the remainder of dividing this expression by the t value.
Calculates the remainder of dividing this expression by the other expression.
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.ROWS mode and specified start bound.
Defines the set of rows constituting the window frame, which is a subset of the current partition. Window frame uses WindowFrameUnit.ROWS mode and specified start and end bounds.
Returns the sample standard deviation of the non-null input values, or null
if there are no non-null values.
Appends the SQL representation of this expression to the specified queryBuilder.