Package org.h2.expression.analysis
Enum WindowFunctionType
- All Implemented Interfaces:
Serializable
,Comparable<WindowFunctionType>
,java.lang.constant.Constable
A type of a window function.
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>>
-
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionThe type for CUME_DIST() window function.The type for DENSE_RANK() window function.The type for FIRST_VALUE() window function.The type for LAG() window function.The type for LAST_VALUE() window function.The type for LEAD() window function.The type for NTH_VALUE() window function.The type for NTILE() window function.The type for PERCENT_RANK() window function.The type for RANK() window function.The type for RATIO_TO_REPORT() window function.The type for ROW_NUMBER() window function. -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic WindowFunctionType
Returns the type of window function with the specified name, or null.getSQL()
Returns SQL representation.boolean
Returns whether window function of this type requires window ordering clause.static WindowFunctionType
Returns the enum constant of this type with the specified name.static WindowFunctionType[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
Enum Constant Details
-
ROW_NUMBER
The type for ROW_NUMBER() window function. -
RANK
The type for RANK() window function. -
DENSE_RANK
The type for DENSE_RANK() window function. -
PERCENT_RANK
The type for PERCENT_RANK() window function. -
CUME_DIST
The type for CUME_DIST() window function. -
NTILE
The type for NTILE() window function. -
LEAD
The type for LEAD() window function. -
LAG
The type for LAG() window function. -
FIRST_VALUE
The type for FIRST_VALUE() window function. -
LAST_VALUE
The type for LAST_VALUE() window function. -
NTH_VALUE
The type for NTH_VALUE() window function. -
RATIO_TO_REPORT
The type for RATIO_TO_REPORT() window function.
-
-
Constructor Details
-
WindowFunctionType
private WindowFunctionType()
-
-
Method Details
-
values
Returns an array containing the constants of this enum type, in the order they are declared.- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is null
-
get
Returns the type of window function with the specified name, or null.- Parameters:
name
- name of a window function- Returns:
- the type of window function, or null.
-
getSQL
Returns SQL representation.- Returns:
- SQL representation.
- See Also:
-
requiresWindowOrdering
public boolean requiresWindowOrdering()Returns whether window function of this type requires window ordering clause.- Returns:
true
if it does,false
if it may be omitted
-