Class TRollupCube
- Namespace
- gudusoft.gsqlparser.nodes
- Assembly
- gudusoft.gsqlparser.dll
The ROLLUP operation in the simple_grouping_clause groups the selected rows based on the values of the first n, n-1, n-2, ... 0 expressions in the GROUP BY specification, and returns a single row of summary for each group.
The CUBE operation in the simple_grouping_clause groups the selected rows based on the values of all possible combinations of expressions in the specification. It returns a single row of summary information for each group.
public class TRollupCube : TParseTreeNode, Visitable
- Inheritance
-
TRollupCube
- Implements
- Inherited Members
Fields
cube
public const int cube = 2
Field Value
rollup
public const int rollup = 1
Field Value
Properties
Items
public virtual TExpressionList Items { get; set; }
Property Value
- TExpressionList
grouping expression list
- See Also
Operation
public virtual int Operation { get; set; }
Property Value
Methods
accept(TParseTreeVisitor)
public override void accept(TParseTreeVisitor v)
Parameters
acceptChildren(TParseTreeVisitor)
public override void acceptChildren(TParseTreeVisitor v)
Parameters
doParse(TCustomSqlStatement, ESqlClause)
analyze this node
public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)
Parameters
psqlTCustomSqlStatementplocationESqlClause
init(object)
Initialize a query tree node.
public override void init(object arg1)
Parameters
arg1object
setOperation(int)
public void setOperation(int op)
Parameters
opint