Module org.jooq
Package org.jooq

Interface AggregateFunction<T>

    • Method Detail

      • keepDenseRankFirstOrderBy

        @Support(ORACLE)
        @Pro
        AggregateFilterStep<T> keepDenseRankFirstOrderBy​(OrderField<?>... fields)
        Restrict this aggregate function to FIRST values

        An example:

         MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1)
         

        This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

      • keepDenseRankFirstOrderBy

        @Support(ORACLE)
        @Pro
        AggregateFilterStep<T> keepDenseRankFirstOrderBy​(Collection<? extends OrderField<?>> fields)
        Restrict this aggregate function to FIRST values

        An example:

         MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1)
         

        This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

      • keepDenseRankLastOrderBy

        @Support(ORACLE)
        @Pro
        AggregateFilterStep<T> keepDenseRankLastOrderBy​(OrderField<?>... fields)
        Restrict this aggregate function to FIRST values

        An example:

         MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1)
         

        This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

      • keepDenseRankLastOrderBy

        @Support(ORACLE)
        @Pro
        AggregateFilterStep<T> keepDenseRankLastOrderBy​(Collection<? extends OrderField<?>> fields)
        Restrict this aggregate function to FIRST values

        An example:

         MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1)
         

        This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.