Interface WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

Namespace

LinqToDB

Assembly

linq2db.dll

Additional WITHIN GROUP ORDER BY columns for a windowed ordered-set aggregate, plus an optional OVER (PARTITION BY ...).

public interface WindowFunctionBuilder.IOrderedSetWindowThenBy<out TValue> : WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IDefinedFunction<TValue>>, WindowFunctionBuilder.IDefinedFunction<TValue>

Type Parameters

TValue

Inherited Members

WindowFunctionBuilder.IPartitionPart<WindowFunctionBuilder.IDefinedFunction<TValue>>.PartitionBy(params object[])

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Methods

ThenBy(object?)

Adds an additional WITHIN GROUP ORDER BY column.

WindowFunctionBuilder.IOrderedSetWindowThenBy<out TValue> ThenBy(object? orderBy)

Parameters

orderBy object

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

ThenBy(object?, NullsPosition)

Adds an additional WITHIN GROUP ORDER BY column with NULLS position.

WindowFunctionBuilder.IOrderedSetWindowThenBy<out TValue> ThenBy(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

ThenByDesc(object?)

Adds an additional WITHIN GROUP ORDER BY column (descending).

WindowFunctionBuilder.IOrderedSetWindowThenBy<out TValue> ThenByDesc(object? orderBy)

Parameters

orderBy object

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

ThenByDesc(object?, NullsPosition)

Adds an additional WITHIN GROUP ORDER BY column (descending) with NULLS position.

WindowFunctionBuilder.IOrderedSetWindowThenBy<out TValue> ThenByDesc(object? orderBy, Sql.NullsPosition nulls)

Parameters

orderBy object

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>