Interface WindowFunctionBuilder.IOrderedSetWindowMultiOrder

Namespace

LinqToDB

Assembly

linq2db.dll

Within-group ORDER BY for a windowed multi-key ordered-set aggregate (Sql.Window.PercentileDisc): the first sort key, then ThenBy/ThenByDesc, then an optional OVER (PARTITION BY ...).

public interface WindowFunctionBuilder.IOrderedSetWindowMultiOrder

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

OrderByDesc<TValue>(TValue)

Specifies the first WITHIN GROUP ORDER BY column (descending).

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue> OrderByDesc<TValue>(TValue orderBy)

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

Type Parameters

TValue

OrderByDesc<TValue>(TValue, NullsPosition)

Specifies the first WITHIN GROUP ORDER BY column (descending) with NULLS position.

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue> OrderByDesc<TValue>(TValue orderBy, Sql.NullsPosition nulls)

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue)

Specifies the first WITHIN GROUP ORDER BY column.

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue> OrderBy<TValue>(TValue orderBy)

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue, NullsPosition)

Specifies the first WITHIN GROUP ORDER BY column with NULLS position.

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue> OrderBy<TValue>(TValue orderBy, Sql.NullsPosition nulls)

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowThenBy<TValue>

Type Parameters

TValue