Top Description Fields Constructors Methods
org.h2.expression.analysis

public final Enum WindowFunctionType

extends Enum<WindowFunctionType>
Class Inheritance
A type of a window function.

Field Summary

Modifier and TypeField and Description
public static final WindowFunctionType
CUME_DIST

The type for CUME_DIST() window function.

public static final WindowFunctionType
DENSE_RANK

The type for DENSE_RANK() window function.

public static final WindowFunctionType
FIRST_VALUE

The type for FIRST_VALUE() window function.

public static final WindowFunctionType
LAG

The type for LAG() window function.

public static final WindowFunctionType
LAST_VALUE

The type for LAST_VALUE() window function.

public static final WindowFunctionType
LEAD

The type for LEAD() window function.

public static final WindowFunctionType
NTH_VALUE

The type for NTH_VALUE() window function.

public static final WindowFunctionType
NTILE

The type for NTILE() window function.

public static final WindowFunctionType
PERCENT_RANK

The type for PERCENT_RANK() window function.

public static final WindowFunctionType
RANK

The type for RANK() window function.

public static final WindowFunctionType
RATIO_TO_REPORT

The type for RATIO_TO_REPORT() window function.

public static final WindowFunctionType
ROW_NUMBER

The type for ROW_NUMBER() window function.

Constructor Summary

AccessConstructor and Description
private
WindowFunctionType()

Method Summary

Modifier and TypeMethod and Description
public static WindowFunctionType

Returns:

the type of window function, or null.
get(String
name of a window function
name)

Returns the type of window function with the specified name, or null.

public String

Returns:

SQL representation.
getSQL()

Returns SQL representation.

public boolean

Returns:

true if it does, false if it may be omitted
requiresWindowOrdering()

Returns whether window function of this type requires window ordering clause.

public static WindowFunctionType
valueOf(String name)

public static WindowFunctionType[]
values()

Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf

Field Detail

CUME_DISTback to summary
public static final WindowFunctionType CUME_DIST

The type for CUME_DIST() window function.

DENSE_RANKback to summary
public static final WindowFunctionType DENSE_RANK

The type for DENSE_RANK() window function.

FIRST_VALUEback to summary
public static final WindowFunctionType FIRST_VALUE

The type for FIRST_VALUE() window function.

LAGback to summary
public static final WindowFunctionType LAG

The type for LAG() window function.

LAST_VALUEback to summary
public static final WindowFunctionType LAST_VALUE

The type for LAST_VALUE() window function.

LEADback to summary
public static final WindowFunctionType LEAD

The type for LEAD() window function.

NTH_VALUEback to summary
public static final WindowFunctionType NTH_VALUE

The type for NTH_VALUE() window function.

NTILEback to summary
public static final WindowFunctionType NTILE

The type for NTILE() window function.

PERCENT_RANKback to summary
public static final WindowFunctionType PERCENT_RANK

The type for PERCENT_RANK() window function.

RANKback to summary
public static final WindowFunctionType RANK

The type for RANK() window function.

RATIO_TO_REPORTback to summary
public static final WindowFunctionType RATIO_TO_REPORT

The type for RATIO_TO_REPORT() window function.

ROW_NUMBERback to summary
public static final WindowFunctionType ROW_NUMBER

The type for ROW_NUMBER() window function.

Constructor Detail

WindowFunctionTypeback to summary
private WindowFunctionType()

Method Detail

getback to summary
public static WindowFunctionType get(String name)

Returns the type of window function with the specified name, or null.

Parameters
name:String

name of a window function

Returns:WindowFunctionType

the type of window function, or null.

getSQLback to summary
public String getSQL()

Returns SQL representation.

Returns:String

SQL representation.

See Also
org.h2.expression.Expression#getSQL(int)
requiresWindowOrderingback to summary
public boolean requiresWindowOrdering()

Returns whether window function of this type requires window ordering clause.

Returns:boolean

true if it does, false if it may be omitted

valueOfback to summary
public static WindowFunctionType valueOf(String name)
valuesback to summary
public static WindowFunctionType[] values()