Class Win

Assembly: redb.Core.dll

Static helper for window functions
Used in Select to create ROW_NUMBER(), RANK(), SUM() OVER(), etc. expressions.

public static class Win
Code Examples:Window - RowNumberWindow - Running SumWindow - Lag/LeadWindow - Rank/DenseRankWindow - Ntile +8 more

Inheritance

Object→Win

Methods

Avg(decimal)

AVG(field) OVER (...)

public static double Avg(decimal value)

Avg(double)

public static double Avg(double value)

Avg(int)

public static double Avg(int value)

Avg(long)

public static double Avg(long value)

Count()

COUNT(*) OVER (...)

public static int Count()

DenseRank()

DENSE_RANK() OVER (...)

public static long DenseRank()

FirstValue<T>(T)

FIRST_VALUE(field) OVER (...)

public static T FirstValue<T>(T value)

Lag<T>(T)

LAG(field) OVER (...)

public static T Lag<T>(T value)

LastValue<T>(T)

LAST_VALUE(field) OVER (...)

public static T LastValue<T>(T value)

Lead<T>(T)

LEAD(field) OVER (...)

public static T Lead<T>(T value)

Max<T>(T)

MAX(field) OVER (...)

public static T Max<T>(T value)

Min<T>(T)

MIN(field) OVER (...)

public static T Min<T>(T value)

Ntile(int)

NTILE(n) OVER (...)

public static int Ntile(int buckets)

Rank()

RANK() OVER (...)

public static long Rank()

RowNumber()

ROW_NUMBER() OVER (...)

public static long RowNumber()

Sum(decimal)

SUM(field) OVER (...)

public static decimal Sum(decimal value)

Sum(double)

public static double Sum(double value)

Sum(int)

public static int Sum(int value)

Sum(long)

public static long Sum(long value)