Function grouping_id

  • grouping_id(...columns: string[]): Column

    Aggregate function: returns the level of grouping, equals to

    {{{ (grouping(c1) <<; (n-1)) + (grouping(c2) <<; (n-2)) + ... + grouping(cn) }}}

    Parameters

    • ...columns: string[]

    Returns Column

    Note

    The list of columns should match with grouping columns exactly, or empty (means all the grouping columns).

  • grouping_id(...columns: Column[]): Column

    Aggregate function: returns the level of grouping, equals to

    {{{ (grouping(c1) <<; (n-1)) + (grouping(c2) <<; (n-2)) + ... + grouping(cn) }}}

    Parameters

    Returns Column

    Note

    The list of columns should match with grouping columns exactly, or empty (means all the grouping columns).

Settings

Member Visibility