MssqlWindowFunction enum

Window functions emitted by the query builder.

Inheritance
Available extensions

Values

rowNumber → const MssqlWindowFunction

ROW_NUMBER(): 1, 2, 3 … with ties broken arbitrarily.

const MssqlWindowFunction('ROW_NUMBER', ranking: true)
rank → const MssqlWindowFunction

RANK(): ties share a number and the next one skips.

const MssqlWindowFunction('RANK', ranking: true)
denseRank → const MssqlWindowFunction

DENSE_RANK(): ties share a number and the next one does not skip.

const MssqlWindowFunction('DENSE_RANK', ranking: true)
ntile → const MssqlWindowFunction

NTILE(n): the partition split into n groups as evenly as it divides.

const MssqlWindowFunction('NTILE', ranking: true)
lag → const MssqlWindowFunction

LAG(x, n, default): the value n rows earlier in the partition.

const MssqlWindowFunction('LAG', ranking: false)
lead → const MssqlWindowFunction

LEAD(x, n, default): the value n rows later.

const MssqlWindowFunction('LEAD', ranking: false)

Properties

hashCode → int
The hash code for this object.
no setterinherited
index → int
A numeric identifier for the enumerated value.
no setterinherited
name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.
no setter
ranking → bool
Whether the function ranks rows instead of reading a row value.
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sql → String
final

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Constants

values → const List<MssqlWindowFunction>
A constant List of the values in this enum, in order of their declaration.