Interface WindowFunctionBuilder.IOnlyOrderByPart

Namespace

LinqToDB

Assembly

linq2db.dll

Provides ORDER BY for ordered-set aggregate functions (e.g. PERCENTILE_CONT) that require exactly one ordering column.

public interface WindowFunctionBuilder.IOnlyOrderByPart

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

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetFilter<TValue>

Type Parameters

TValue

OrderByDesc<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetFilter<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue)

Specifies the single ORDER BY column for the WITHIN GROUP clause.

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IOrderedSetFilter<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IOrderedSetFilter<TValue>

Type Parameters

TValue