Interface WindowFunctionBuilder.IMultipleOrderByPart

Namespace

LinqToDB

Assembly

linq2db.dll

Provides ORDER BY for ordered-set aggregate functions (e.g. PERCENTILE_DISC) that allow multiple ordering columns.

public interface WindowFunctionBuilder.IMultipleOrderByPart

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

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

Type Parameters

TValue

OrderByDesc<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue)

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

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

Parameters

orderBy TValue

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

Type Parameters

TValue

OrderBy<TValue>(TValue, NullsPosition)

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

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

Parameters

orderBy TValue

nulls Sql.NullsPosition

Returns

WindowFunctionBuilder.IMultipleThenByPart<TValue>

Type Parameters

TValue