Class SqlGroupingFunction

  • All Implemented Interfaces:
    Context, Wrapper

    class SqlGroupingFunction
    extends SqlAbstractGroupFunction
    The GROUPING function.

    Accepts 1 or more arguments. Example: GROUPING(deptno, gender) returns 3 if both deptno and gender are being grouped, 2 if only deptno is being grouped, 1 if only gender is being groped, 0 if neither deptno nor gender are being grouped.

    This function is defined in the SQL standard. GROUPING_ID is a non-standard synonym.

    Some examples are in

    • Constructor Detail

      • SqlGroupingFunction

        SqlGroupingFunction​(java.lang.String name)