Interface WindowFunctionBuilder.IOrderedSetWindowSingleOrder

Namespace

LinqToDB

Assembly

linq2db.dll

Within-group ORDER BY for a windowed single-key ordered-set aggregate (Sql.Window.PercentileCont): the sort key, then an optional OVER (PARTITION BY ...).

public interface WindowFunctionBuilder.IOrderedSetWindowSingleOrder

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 single WITHIN GROUP ORDER BY column (descending).

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetWindowPartition<TValue>

Type Parameters

TValue

OrderByDesc<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowPartition<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue)

Specifies the single WITHIN GROUP ORDER BY column.

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetWindowPartition<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetWindowPartition<TValue>

Type Parameters

TValue