Class TGroupBy

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

This class represents group by clause and having clause.

Specify the GROUP BY clause if you want the database to group the selected rows based on the value of expr(s) for each row and return a single row of summary information for each group.

If this clause contains CUBE or ROLLUP extensions, then the database produces superaggregate groupings in addition to the regular groupings.

Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE. If you omit this clause, then the database returns summary rows for all groups.

public class TGroupBy : TParseTreeNode, Visitable

Inheritance

object

TParseTreeNode

TGroupBy

Implements

Visitable

Inherited Members

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object, object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Properties

BY

public virtual TSourceToken BY { get; set; }

Property Value

TSourceToken

GROUP

public virtual TSourceToken GROUP { get; set; }

Property Value

TSourceToken

HAVING

public virtual TSourceToken HAVING { get; set; }

Property Value

TSourceToken

HavingClause

Restrict the groups of returned rows to those groups for which the specified condition is TRUE.

If you omit this clause, then the database returns summary rows for all groups. @return

public virtual TExpression HavingClause { get; set; }

Property Value

TExpression

Items

Items in group by clause, can be expr, rollup_cube_clause and grouping_sets_clause.

public virtual TGroupByItemList Items { get; set; }

Property Value

TGroupByItemList

See Also

TExpression

TRollupCube

TGroupingSet

RollupModifier

public virtual bool RollupModifier { get; set; }

Property Value

bool

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParse(TCustomSqlStatement, ESqlClause)

analyze this node

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

Parameters

psql TCustomSqlStatement

plocation ESqlClause

init(object, object)

public override void init(object arg1, object arg2)

Parameters

arg1 object

arg2 object

setBY(TSourceToken)

public void setBY(TSourceToken st)

Parameters

st TSourceToken

setGROUP(TSourceToken)

public void setGROUP(TSourceToken st)

Parameters

st TSourceToken

setHAVING(TSourceToken)

public void setHAVING(TSourceToken st)

Parameters

st TSourceToken