Class SqlNode.WindowFunctions

Namespace

LfrlAnvil.Sql.Expressions

Assembly

LfrlAnvil.Sql.Core.dll

Creates instances of SqlAggregateFunctionExpressionNode type that represent window functions.

public static class SqlNode.WindowFunctions

Inheritance

object

SqlNode.WindowFunctions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

CumulativeDistribution()

Creates a new SqlCumulativeDistributionWindowFunctionExpressionNode instance.

[Pure]
public static SqlCumulativeDistributionWindowFunctionExpressionNode CumulativeDistribution()

Returns

SqlCumulativeDistributionWindowFunctionExpressionNode

New SqlCumulativeDistributionWindowFunctionExpressionNode instance.

DenseRank()

Creates a new SqlDenseRankWindowFunctionExpressionNode instance.

[Pure]
public static SqlDenseRankWindowFunctionExpressionNode DenseRank()

Returns

SqlDenseRankWindowFunctionExpressionNode

New SqlDenseRankWindowFunctionExpressionNode instance.

FirstValue(SqlExpressionNode)

Creates a new SqlFirstValueWindowFunctionExpressionNode instance.

[Pure]
public static SqlFirstValueWindowFunctionExpressionNode FirstValue(SqlExpressionNode expression)

Parameters

expression SqlExpressionNode

Expression to calculate the first value for.

Returns

SqlFirstValueWindowFunctionExpressionNode

New SqlFirstValueWindowFunctionExpressionNode instance.

Lag(SqlExpressionNode, SqlExpressionNode?, SqlExpressionNode?)

Creates a new SqlLagWindowFunctionExpressionNode instance.

[Pure]
public static SqlLagWindowFunctionExpressionNode Lag(SqlExpressionNode expression, SqlExpressionNode? offset = null, SqlExpressionNode? @default = null)

Parameters

expression SqlExpressionNode

Expression to calculate the lag for.

offset SqlExpressionNode

Optional offset. Equal to SQL literal that represents 1 by default.

default SqlExpressionNode

Optional default value. Equal to null by default.

Returns

SqlLagWindowFunctionExpressionNode

New SqlLagWindowFunctionExpressionNode instance.

LastValue(SqlExpressionNode)

Creates a new SqlLastValueWindowFunctionExpressionNode instance.

[Pure]
public static SqlLastValueWindowFunctionExpressionNode LastValue(SqlExpressionNode expression)

Parameters

expression SqlExpressionNode

Expression to calculate the last value for.

Returns

SqlLastValueWindowFunctionExpressionNode

New SqlLastValueWindowFunctionExpressionNode instance.

Lead(SqlExpressionNode, SqlExpressionNode?, SqlExpressionNode?)

Creates a new SqlLeadWindowFunctionExpressionNode instance.

[Pure]
public static SqlLeadWindowFunctionExpressionNode Lead(SqlExpressionNode expression, SqlExpressionNode? offset = null, SqlExpressionNode? @default = null)

Parameters

expression SqlExpressionNode

Expression to calculate the lead for.

offset SqlExpressionNode

Optional offset. Equal to SQL literal that represents 1 by default.

default SqlExpressionNode

Optional default value. Equal to null by default.

Returns

SqlLeadWindowFunctionExpressionNode

New SqlLeadWindowFunctionExpressionNode instance.

NTile(SqlExpressionNode)

Creates a new SqlNTileWindowFunctionExpressionNode instance.

[Pure]
public static SqlNTileWindowFunctionExpressionNode NTile(SqlExpressionNode n)

Parameters

n SqlExpressionNode

Number of groups.

Returns

SqlNTileWindowFunctionExpressionNode

New SqlNTileWindowFunctionExpressionNode instance.

NthValue(SqlExpressionNode, SqlExpressionNode)

Creates a new SqlNthValueWindowFunctionExpressionNode instance.

[Pure]
public static SqlNthValueWindowFunctionExpressionNode NthValue(SqlExpressionNode expression, SqlExpressionNode n)

Parameters

expression SqlExpressionNode

Expression to calculate the n-th value for.

n SqlExpressionNode

Row's position.

Returns

SqlNthValueWindowFunctionExpressionNode

New SqlNthValueWindowFunctionExpressionNode instance.

Rank()

Creates a new SqlRankWindowFunctionExpressionNode instance.

[Pure]
public static SqlRankWindowFunctionExpressionNode Rank()

Returns

SqlRankWindowFunctionExpressionNode

New SqlRankWindowFunctionExpressionNode instance.

RowNumber()

Creates a new SqlRowNumberWindowFunctionExpressionNode instance.

[Pure]
public static SqlRowNumberWindowFunctionExpressionNode RowNumber()

Returns

SqlRowNumberWindowFunctionExpressionNode

New SqlRowNumberWindowFunctionExpressionNode instance.