Table of Contents

Class AnalyticFunctions

Namespace
LinqToDB
Assembly
linq2db.dll
public static class AnalyticFunctions
Inheritance
AnalyticFunctions

Fields

FunctionToken

Token name for analytic function. Used for resolving method chain.

public const string FunctionToken = "function"

Field Value

string

Methods

Average<T>(ISqlExtension?, object?) 

[Sql.Extension("AVG({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Average<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Average<T>(ISqlExtension?, object?, AggregateModifier) 

[Sql.Extension("AVG({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Average<T>(this Sql.ISqlExtension? ext, object? expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr object
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Average<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("AVG({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static double Average<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

double

Type Parameters

TEntity
TV

Average<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("AVG({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static double Average<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

double

Type Parameters

TEntity
TV

Corr<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("CORR({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Corr<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Corr<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>) 

[Sql.Extension("CORR({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal Corr<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)

Parameters

source IEnumerable<T>
expr1 Expression<Func<T, object>>
expr2 Expression<Func<T, object>>

Returns

decimal

Type Parameters

T

Corr<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>) 

[Sql.Extension("CORR({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal Corr<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)

Parameters

source IQueryable<TEntity>
expr1 Expression<Func<TEntity, object>>
expr2 Expression<Func<TEntity, object>>

Returns

decimal

Type Parameters

TEntity

Count(ISqlExtension?) 

[Sql.Extension("COUNT(*)", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<int>

Count(ISqlExtension?, object?, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count(this Sql.ISqlExtension? ext, object? expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr object
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<int>

CountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, object?>) 

[Sql.Extension("COUNT({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static int CountExt<TEntity>(this IEnumerable<TEntity> source, Func<TEntity, object?> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, object>

Returns

int

Type Parameters

TEntity

CountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static int CountExt<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

int

Type Parameters

TEntity
TV

CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static int CountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

int

Type Parameters

TEntity
TV

CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static int CountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = AggregateModifier.None)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

int

Type Parameters

TEntity
TV

Count<T>(ISqlExtension?, T) 

[Sql.Extension("COUNT({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<int> Count<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<int>

Type Parameters

T

CovarPop<T>(ISqlExtension?, T, T) 

[Sql.Extension("COVAR_POP({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> CovarPop<T>(this Sql.ISqlExtension? ext, T expr1, T expr2)

Parameters

ext Sql.ISqlExtension
expr1 T
expr2 T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

CovarPop<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>) 

[Sql.Extension("COVAR_POP({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal CovarPop<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)

Parameters

source IEnumerable<T>
expr1 Expression<Func<T, object>>
expr2 Expression<Func<T, object>>

Returns

decimal

Type Parameters

T

CovarPop<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>) 

[Sql.Extension("COVAR_POP({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal CovarPop<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)

Parameters

source IQueryable<TEntity>
expr1 Expression<Func<TEntity, object>>
expr2 Expression<Func<TEntity, object>>

Returns

decimal

Type Parameters

TEntity

CovarSamp<T>(ISqlExtension?, T, T) 

[Sql.Extension("COVAR_SAMP({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> CovarSamp<T>(this Sql.ISqlExtension? ext, T expr1, T expr2)

Parameters

ext Sql.ISqlExtension
expr1 T
expr2 T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

CovarSamp<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>) 

[Sql.Extension("COVAR_SAMP({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal CovarSamp<T>(this IEnumerable<T> source, Expression<Func<T, object?>> expr1, Expression<Func<T, object?>> expr2)

Parameters

source IEnumerable<T>
expr1 Expression<Func<T, object>>
expr2 Expression<Func<T, object>>

Returns

decimal

Type Parameters

T

CovarSamp<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>) 

[Sql.Extension("COVAR_SAMP({expr1}, {expr2})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal CovarSamp<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object?>> expr1, Expression<Func<TEntity, object?>> expr2)

Parameters

source IQueryable<TEntity>
expr1 Expression<Func<TEntity, object>>
expr2 Expression<Func<TEntity, object>>

Returns

decimal

Type Parameters

TEntity

CumeDist<TR>(ISqlExtension?) 

[Sql.Extension("CUME_DIST()", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<TR> CumeDist<TR>(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<TR>

Type Parameters

TR

CumeDist<TR>(ISqlExtension?, params object?[]) 

[Sql.Extension("CUME_DIST({expr, ', '}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<TR> CumeDist<TR>(this Sql.ISqlExtension? ext, params object?[] expr)

Parameters

ext Sql.ISqlExtension
expr object[]

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderOnly<TR>

Type Parameters

TR

DenseRank(ISqlExtension?) 

[Sql.Extension("DENSE_RANK()", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> DenseRank(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<long>

DenseRank(ISqlExtension?, object?, object?) 

[Sql.Extension("DENSE_RANK({expr1}, {expr2}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long> DenseRank(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long>

Filter<T>(IAnalyticFunctionWithoutWindow<T>, bool) 

[Sql.Extension("{function} FILTER (WHERE {filter})", TokenName = "function", ChainPrecedence = 2, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Filter<T>(this AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> func, bool filter)

Parameters

func AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>
filter bool

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

FirstValue<T>(ISqlExtension?, T, Nulls) 

[Sql.Extension("FIRST_VALUE({expr}){_}{modifier?}", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true, Configuration = "SqlServer.2022")]
[Sql.Extension("FIRST_VALUE({expr}{_}{modifier?})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> FirstValue<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

KeepFirst<TR>(IAggregateFunction<TR>) 

[Sql.Extension("{function} KEEP (DENSE_RANK FIRST {order_by_clause}){_}{over?}", ChainPrecedence = 10, IsWindowFunction = true)]
public static AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR> KeepFirst<TR>(this AnalyticFunctions.IAggregateFunction<TR> ext)

Parameters

ext AnalyticFunctions.IAggregateFunction<TR>

Returns

AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR>

Type Parameters

TR

KeepLast<TR>(IAggregateFunction<TR>) 

[Sql.Extension("{function} KEEP (DENSE_RANK LAST {order_by_clause}){_}{over?}", ChainPrecedence = 10, IsWindowFunction = true)]
public static AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR> KeepLast<TR>(this AnalyticFunctions.IAggregateFunction<TR> ext)

Parameters

ext AnalyticFunctions.IAggregateFunction<TR>

Returns

AnalyticFunctions.INeedOrderByAndMaybeOverWithPartition<TR>

Type Parameters

TR

Lag<T>(ISqlExtension?, T) 

[Sql.Extension("LAG({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lag<T>(ISqlExtension?, T, Nulls) 

[Sql.Extension("LAG({expr}{_}{modifier?})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lag<T>(ISqlExtension?, T, Nulls, int, T) 

[Sql.Extension("LAG({expr}{_}{modifier?}, {offset}, {default})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls, int offset, T @default)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls
offset int
default T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lag<T>(ISqlExtension?, T, int) 

[Sql.Extension("LAG({expr}, {offset})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension? ext, T expr, int offset)

Parameters

ext Sql.ISqlExtension
expr T
offset int

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lag<T>(ISqlExtension?, T, int, T) 

[Sql.Extension("LAG({expr}, {offset}, {default})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lag<T>(this Sql.ISqlExtension? ext, T expr, int offset, T @default)

Parameters

ext Sql.ISqlExtension
expr T
offset int
default T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

LastValue<T>(ISqlExtension?, T, Nulls) 

[Sql.Extension("LAST_VALUE({expr}){_}{modifier?}", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true, Configuration = "SqlServer.2022")]
[Sql.Extension("LAST_VALUE({expr}{_}{modifier?})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> LastValue<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Lead<T>(ISqlExtension?, T) 

[Sql.Extension("LEAD({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lead<T>(ISqlExtension?, T, Nulls) 

[Sql.Extension("LEAD({expr}{_}{modifier?})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lead<T>(ISqlExtension?, T, Nulls, int, T) 

[Sql.Extension("LEAD({expr}{_}{modifier?}, {offset}, {default})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension? ext, T expr, Sql.Nulls nulls, int offset, T @default)

Parameters

ext Sql.ISqlExtension
expr T
nulls Sql.Nulls
offset int
default T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lead<T>(ISqlExtension?, T, int) 

[Sql.Extension("LEAD({expr}, {offset})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension? ext, T expr, int offset)

Parameters

ext Sql.ISqlExtension
expr T
offset int

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

Lead<T>(ISqlExtension?, T, int, T) 

[Sql.Extension("LEAD({expr}, {offset}, {default})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> Lead<T>(this Sql.ISqlExtension? ext, T expr, int offset, T @default)

Parameters

ext Sql.ISqlExtension
expr T
offset int
default T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

ListAgg<T>(ISqlExtension?, T) 

[Sql.Extension("LISTAGG({expr}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string>

Type Parameters

T

ListAgg<T>(ISqlExtension?, T, string) 

[Sql.Extension("LISTAGG({expr}, {delimiter}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this Sql.ISqlExtension? ext, T expr, string delimiter)

Parameters

ext Sql.ISqlExtension
expr T
delimiter string

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderAndMaybePartition<string>

Type Parameters

T

LongCount(ISqlExtension?) 

[Sql.Extension("COUNT(*)", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<long>

LongCount(ISqlExtension?, object?, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount(this Sql.ISqlExtension? ext, object? expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr object
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<long>

LongCountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, object?>) 

[Sql.Extension("COUNT({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static long LongCountExt<TEntity>(this IEnumerable<TEntity> source, Func<TEntity, object?> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, object>

Returns

long

Type Parameters

TEntity

LongCountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static long LongCountExt<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

long

Type Parameters

TEntity
TV

LongCountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("COUNT({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static long LongCountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = AggregateModifier.None)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

long

Type Parameters

TEntity
TV

LongCount<T>(ISqlExtension?, T) 

[Sql.Extension("COUNT({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> LongCount<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<long>

Type Parameters

T

Max<T>(ISqlExtension?, T) 

[Sql.Extension("MAX({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Max<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Max<T>(ISqlExtension?, T, AggregateModifier) 

[Sql.Extension("MAX({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Max<T>(this Sql.ISqlExtension? ext, T expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr T
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Max<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("MAX({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Max<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV

Max<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("MAX({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Max<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV

Median<T>(ISqlExtension?, T) 

[Sql.Extension("MEDIAN({expr}) {over}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IReadyToFunctionOrOverWithPartition<T> Median<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IReadyToFunctionOrOverWithPartition<T>

Type Parameters

T

Median<TEntity, T>(IEnumerable<TEntity>, Func<TEntity, T>) 

[Sql.Extension("MEDIAN({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static long Median<TEntity, T>(this IEnumerable<TEntity> source, Func<TEntity, T> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, T>

Returns

long

Type Parameters

TEntity
T

Median<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("MEDIAN({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static long Median<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

long

Type Parameters

TEntity
TV

Min<T>(ISqlExtension?, T) 

[Sql.Extension("MIN({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Min<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Min<T>(ISqlExtension?, T, AggregateModifier) 

[Sql.Extension("MIN({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Min<T>(this Sql.ISqlExtension? ext, T expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr T
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Min<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("MIN({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Min<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV

Min<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("MIN({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Min<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV

NTile<T>(ISqlExtension?, T) 

[Sql.Extension("NTILE({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> NTile<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

NthValue<T>(ISqlExtension?, T, long) 

[Sql.Extension("NTH_VALUE({expr}, {n})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> NthValue<T>(this Sql.ISqlExtension? ext, T expr, long n)

Parameters

ext Sql.ISqlExtension
expr T
n long

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

NthValue<T>(ISqlExtension?, T, long, From, Nulls) 

[Sql.Extension("NTH_VALUE({expr}, {n}){_}{from?}{_}{nulls?}", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyFromAndNullsModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> NthValue<T>(this Sql.ISqlExtension? ext, T expr, long n, Sql.From from, Sql.Nulls nulls)

Parameters

ext Sql.ISqlExtension
expr T
n long
from Sql.From
nulls Sql.Nulls

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

PercentRank<T>(ISqlExtension?) 

[Sql.Extension("PERCENT_RANK()", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<T> PercentRank<T>(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<T>

Type Parameters

T

PercentRank<T>(ISqlExtension?, params object?[]) 

[Sql.Extension("PERCENT_RANK({expr, ', '}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<T> PercentRank<T>(this Sql.ISqlExtension? ext, params object?[] expr)

Parameters

ext Sql.ISqlExtension
expr object[]

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderOnly<T>

Type Parameters

T

PercentileCont<T>(ISqlExtension?, object?) 

[Sql.Extension("PERCENTILE_CONT({expr}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileCont<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T>

Type Parameters

T

PercentileDisc<T>(ISqlExtension?, object?) 

[Sql.Extension("PERCENTILE_DISC({expr}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileDisc<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.INeedsWithinGroupWithSingleOrderAndMaybePartition<T>

Type Parameters

T

Rank(ISqlExtension?) 

[Sql.Extension("RANK()", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> Rank(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<long>

Rank(ISqlExtension?, params object?[]) 

[Sql.Extension("RANK({expr, ', '}) {within_group}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long> Rank(this Sql.ISqlExtension? ext, params object?[] expr)

Parameters

ext Sql.ISqlExtension
expr object[]

Returns

AnalyticFunctions.INeedsWithinGroupWithOrderOnly<long>

RatioToReport<TR>(ISqlExtension?, object?) 

[Sql.Extension("RATIO_TO_REPORT({expr}) {over}", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IOverWithPartitionNeeded<TR> RatioToReport<TR>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IOverWithPartitionNeeded<TR>

Type Parameters

TR

RegrAvgX<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_AVGX({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrAvgX<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrAvgY<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_AVGY({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrAvgY<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrCount(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_COUNT({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<long> RegrCount(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<long>

RegrIntercept<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_INTERCEPT({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrIntercept<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrR2<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_R2({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrR2<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrSXX<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_SXX({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSXX<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrSXY<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_SXY({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSXY<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrSYY<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_SYY({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSYY<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RegrSlope<T>(ISqlExtension?, object?, object?) 

[Sql.Extension("REGR_SLOPE({expr1}, {expr2})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> RegrSlope<T>(this Sql.ISqlExtension? ext, object? expr1, object? expr2)

Parameters

ext Sql.ISqlExtension
expr1 object
expr2 object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

RowNumber(ISqlExtension?) 

[Sql.Extension("ROW_NUMBER()", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAnalyticFunctionWithoutWindow<long> RowNumber(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

AnalyticFunctions.IAnalyticFunctionWithoutWindow<long>

StdDevPop<T>(ISqlExtension?, object?) 

[Sql.Extension("STDDEV_POP({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDevPop<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

StdDevPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("STDDEV_POP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal StdDevPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

decimal

Type Parameters

TEntity
TV

StdDevPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("STDDEV_POP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal StdDevPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

decimal

Type Parameters

TEntity
TV

StdDevSamp<T>(ISqlExtension?, object?) 

[Sql.Extension("STDDEV_SAMP({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDevSamp<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

StdDevSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("STDDEV_SAMP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal StdDevSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

decimal

Type Parameters

TEntity
TV

StdDevSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("STDDEV_SAMP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal StdDevSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

decimal

Type Parameters

TEntity
TV

StdDev<T>(ISqlExtension?, object?) 

[Sql.Extension("STDEV({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
[Sql.Extension("Oracle", "STDDEV({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDev<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

StdDev<T>(ISqlExtension?, object?, AggregateModifier) 

[Sql.Extension("STDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 1, IsWindowFunction = true)]
[Sql.Extension("Oracle", "STDDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> StdDev<T>(this Sql.ISqlExtension? ext, object? expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr object
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("STDEV({expr})", TokenName = "function", ChainPrecedence = 0, IsWindowFunction = true)]
[Sql.Extension("Oracle", "STDDEV({expr})", TokenName = "function", ChainPrecedence = 0, IsWindowFunction = true)]
public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

double

Type Parameters

TEntity
TV

StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("STDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 0, IsWindowFunction = true)]
[Sql.Extension("Oracle", "STDDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 0, IsWindowFunction = true)]
public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

double

Type Parameters

TEntity
TV

StdDev<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("STDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 0, IsWindowFunction = true)]
[Sql.Extension("Oracle", "STDDEV({modifier?}{_}{expr})", TokenName = "function", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), ChainPrecedence = 0, IsWindowFunction = true)]
public static double StdDev<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = AggregateModifier.None)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

double

Type Parameters

TEntity
TV

Sum<T>(ISqlExtension?, T) 

[Sql.Extension("SUM({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Sum<T>(this Sql.ISqlExtension? ext, T expr)

Parameters

ext Sql.ISqlExtension
expr T

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Sum<T>(ISqlExtension?, T, AggregateModifier) 

[Sql.Extension("SUM({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Sum<T>(this Sql.ISqlExtension? ext, T expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr T
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

VarPop<T>(ISqlExtension?, object?) 

[Sql.Extension("VAR_POP({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> VarPop<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

VarPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("VAR_POP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal VarPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

decimal

Type Parameters

TEntity
TV

VarPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("VAR_POP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal VarPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

decimal

Type Parameters

TEntity
TV

VarSamp<T>(ISqlExtension?, object?) 

[Sql.Extension("VAR_SAMP({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> VarSamp<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

VarSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("VAR_SAMP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal VarSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

decimal

Type Parameters

TEntity
TV

VarSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>) 

[Sql.Extension("VAR_SAMP({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static decimal VarSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>

Returns

decimal

Type Parameters

TEntity
TV

Variance<T>(ISqlExtension?, object?) 

[Sql.Extension("VARIANCE({expr})", TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Variance<T>(this Sql.ISqlExtension? ext, object? expr)

Parameters

ext Sql.ISqlExtension
expr object

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Variance<T>(ISqlExtension?, object?, AggregateModifier) 

[Sql.Extension("VARIANCE({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), TokenName = "function", ChainPrecedence = 1, IsWindowFunction = true)]
public static AnalyticFunctions.IAggregateFunctionSelfContained<T> Variance<T>(this Sql.ISqlExtension? ext, object? expr, Sql.AggregateModifier modifier)

Parameters

ext Sql.ISqlExtension
expr object
modifier Sql.AggregateModifier

Returns

AnalyticFunctions.IAggregateFunctionSelfContained<T>

Type Parameters

T

Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>) 

[Sql.Extension("VARIANCE({expr})", IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>

Returns

TV

Type Parameters

TEntity
TV

Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, AggregateModifier) 

[Sql.Extension("VARIANCE({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, Sql.AggregateModifier modifier)

Parameters

source IEnumerable<TEntity>
expr Func<TEntity, TV>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV

Variance<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, AggregateModifier) 

[Sql.Extension("VARIANCE({modifier?}{_}{expr})", BuilderType = typeof(AnalyticFunctions.ApplyAggregateModifier), IsWindowFunction = true, ChainPrecedence = 0)]
public static TV Variance<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, Sql.AggregateModifier modifier = AggregateModifier.None)

Parameters

source IQueryable<TEntity>
expr Expression<Func<TEntity, TV>>
modifier Sql.AggregateModifier

Returns

TV

Type Parameters

TEntity
TV