Agg

java.lang.Object
- org.jooq.lambda.Agg

```
public class Agg
extends Object
```
A set of additional Collector implementations.
The class name isn't set in stone and will change.

Constructor Summary

Constructors

Constructor and Description
`Agg()`

Method Summary

Methods

Modifier and Type	Method and Description
`static Collector<Boolean,?,Boolean>`	`allMatch()` Get a `Collector` that calculates the `ALL()` function.
`static <T> Collector<T,?,Boolean>`	`allMatch(Predicate<? super T> predicate)` Get a `Collector` that calculates the `ALL()` function.
`static Collector<Boolean,?,Boolean>`	`anyMatch()` Get a `Collector` that calculates the `ANY()` function.
`static <T> Collector<T,?,Boolean>`	`anyMatch(Predicate<? super T> predicate)` Get a `Collector` that calculates the `ANY()` function.
`static <T> Collector<T,?,Optional<T>>`	`avg()` Get a `Collector` that calculates the `AVG()` for any type of `Number`.
`static <T,U> Collector<T,?,Optional<U>>`	`avg(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `AVG()` for any type of `Number`.
`static <T> Collector<T,?,Long>`	`count()` Get a `Collector` that calculates the `COUNT(*)` function.
`static <T> Collector<T,?,Long>`	`countDistinct()` Get a `Collector` that calculates the `COUNT (DISTINCT *)` function.
`static <T,U> Collector<T,?,Long>`	`countDistinctBy(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `COUNT (DISTINCT expr)` function.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<Long>>`	`denseRank(T value)` Get a `Collector` that calculates the `DENSE_RANK()` function given natural ordering.
`static <T> Collector<T,?,Optional<Long>>`	`denseRank(T value, Comparator<? super T> comparator)` Get a `Collector` that calculates the `DENSE_RANK()` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Long>>`	`denseRankBy(U value, Function<? super T,? extends U> function)` Get a `Collector` that calculates the derived `DENSE_RANK()` function given natural ordering.
`static <T,U> Collector<T,?,Optional<Long>>`	`denseRankBy(U value, Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the derived `DENSE_RANK()` function given a specific ordering.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<T>>`	`max()` Get a `Collector` that calculates the `MAX()` function.
`static <T> Collector<T,?,Optional<T>>`	`max(Comparator<? super T> comparator)` Get a `Collector` that calculates the `MAX()` function.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>>`	`max(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `MAX()` function.
`static <T,U> Collector<T,?,Optional<U>>`	`max(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `MAX()` function.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>>`	`maxBy(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `MAX()` function.
`static <T,U> Collector<T,?,Optional<T>>`	`maxBy(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `MIN()` function.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<T>>`	`median()` Get a `Collector` that calculates the `MEDIAN()` function given natural ordering.
`static <T> Collector<T,?,Optional<T>>`	`median(Comparator<? super T> comparator)` Get a `Collector` that calculates the `MEDIAN()` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>>`	`median(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `MEDIAN()` function given a specific ordering.
`static <T,U> Collector<T,?,Optional<U>>`	`median(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `MEDIAN()` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>>`	`medianBy(Function<? super T,? extends U> function)` Get a `Collector` that calculates the derived `MEDIAN()` function given natural ordering.
`static <T,U> Collector<T,?,Optional<T>>`	`medianBy(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the derived `MEDIAN()` function given a specific ordering.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<T>>`	`min()` Get a `Collector` that calculates the `MIN()` function.
`static <T> Collector<T,?,Optional<T>>`	`min(Comparator<? super T> comparator)` Get a `Collector` that calculates the `MIN()` function.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>>`	`min(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `MIN()` function.
`static <T,U> Collector<T,?,Optional<U>>`	`min(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `MIN()` function.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>>`	`minBy(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `MIN()` function.
`static <T,U> Collector<T,?,Optional<T>>`	`minBy(Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `MIN()` function.
`static <T> Collector<T,?,Optional<T>>`	`mode()` Get a `Collector` that calculates the `MODE()` function.
`static Collector<Boolean,?,Boolean>`	`noneMatch()` Get a `Collector` that calculates the `NONE()` function.
`static <T> Collector<T,?,Boolean>`	`noneMatch(Predicate<? super T> predicate)` Get a `Collector` that calculates the `NONE()` function.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<T>>`	`percentile(double percentile)` Get a `Collector` that calculates the `PERCENTILE_DISC(percentile)` function given natural ordering.
`static <T> Collector<T,?,Optional<T>>`	`percentile(double percentile, Comparator<? super T> comparator)` Get a `Collector` that calculates the `PERCENTILE_DISC(percentile)` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>>`	`percentile(double percentile, Function<? super T,? extends U> function)` Get a `Collector` that calculates the `PERCENTILE_DISC(percentile)` function given a specific ordering.
`static <T,U> Collector<T,?,Optional<U>>`	`percentile(double percentile, Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the `PERCENTILE_DISC(percentile)` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>>`	`percentileBy(double percentile, Function<? super T,? extends U> function)` Get a `Collector` that calculates the derived `PERCENTILE_DISC(percentile)` function given natural ordering.
`static <T,U> Collector<T,?,Optional<T>>`	`percentileBy(double percentile, Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the derived `PERCENTILE_DISC(percentile)` function given a specific ordering.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<Double>>`	`percentRank(T value)` Get a `Collector` that calculates the `PERCENT_RANK()` function given natural ordering.
`static <T> Collector<T,?,Optional<Double>>`	`percentRank(T value, Comparator<? super T> comparator)` Get a `Collector` that calculates the `PERCENT_RANK()` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Double>>`	`percentRankBy(U value, Function<? super T,? extends U> function)` Get a `Collector` that calculates the derived `PERCENT_RANK()` function given natural ordering.
`static <T,U> Collector<T,?,Optional<Double>>`	`percentRankBy(U value, Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the derived `PERCENT_RANK()` function given a specific ordering.
`static <T extends Comparable<? super T>> Collector<T,?,Optional<Long>>`	`rank(T value)` Get a `Collector` that calculates the `RANK()` function given natural ordering.
`static <T> Collector<T,?,Optional<Long>>`	`rank(T value, Comparator<? super T> comparator)` Get a `Collector` that calculates the `RANK()` function given a specific ordering.
`static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Long>>`	`rankBy(U value, Function<? super T,? extends U> function)` Get a `Collector` that calculates the derived `RANK()` function given natural ordering.
`static <T,U> Collector<T,?,Optional<Long>>`	`rankBy(U value, Function<? super T,? extends U> function, Comparator<? super U> comparator)` Get a `Collector` that calculates the derived `RANK()` function given a specific ordering.
`static <T> Collector<T,?,Optional<T>>`	`sum()` Get a `Collector` that calculates the `SUM()` for any type of `Number`.
`static <T,U> Collector<T,?,Optional<U>>`	`sum(Function<? super T,? extends U> function)` Get a `Collector` that calculates the `SUM()` for any type of `Number`.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail
- Agg
```
public Agg()
```

Method Detail

count
```
public static <T> Collector<T,?,Long> count()
```
Get a Collector that calculates the COUNT(*) function.

countDistinct
```
public static <T> Collector<T,?,Long> countDistinct()
```
Get a Collector that calculates the COUNT (DISTINCT *) function.

countDistinctBy

public static <T,U> Collector<T,?,Long> countDistinctBy(Function<? super T,? extends U> function)

Get a Collector that calculates the COUNT (DISTINCT expr) function.

sum
```
public static <T> Collector<T,?,Optional<T>> sum()
```
Get a Collector that calculates the SUM() for any type of Number.

sum

public static <T,U> Collector<T,?,Optional<U>> sum(Function<? super T,? extends U> function)

Get a Collector that calculates the SUM() for any type of Number.

avg
```
public static <T> Collector<T,?,Optional<T>> avg()
```
Get a Collector that calculates the AVG() for any type of Number.

avg

public static <T,U> Collector<T,?,Optional<U>> avg(Function<? super T,? extends U> function)

Get a Collector that calculates the AVG() for any type of Number.

min

public static <T extends Comparable<? super T>> Collector<T,?,Optional<T>> min()

Get a Collector that calculates the MIN() function.

min

public static <T> Collector<T,?,Optional<T>> min(Comparator<? super T> comparator)

Get a Collector that calculates the MIN() function.

min

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>> min(Function<? super T,? extends U> function)

Get a Collector that calculates the MIN() function.

min

public static <T,U> Collector<T,?,Optional<U>> min(Function<? super T,? extends U> function,
                                                   Comparator<? super U> comparator)

Get a Collector that calculates the MIN() function.

minBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>> minBy(Function<? super T,? extends U> function)

Get a Collector that calculates the MIN() function.

minBy

public static <T,U> Collector<T,?,Optional<T>> minBy(Function<? super T,? extends U> function,
                                                     Comparator<? super U> comparator)

Get a Collector that calculates the MIN() function.

max

public static <T extends Comparable<? super T>> Collector<T,?,Optional<T>> max()

Get a Collector that calculates the MAX() function.

max

public static <T> Collector<T,?,Optional<T>> max(Comparator<? super T> comparator)

Get a Collector that calculates the MAX() function.

max

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>> max(Function<? super T,? extends U> function)

Get a Collector that calculates the MAX() function.

max

public static <T,U> Collector<T,?,Optional<U>> max(Function<? super T,? extends U> function,
                                                   Comparator<? super U> comparator)

Get a Collector that calculates the MAX() function.

maxBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>> maxBy(Function<? super T,? extends U> function)

Get a Collector that calculates the MAX() function.

maxBy

public static <T,U> Collector<T,?,Optional<T>> maxBy(Function<? super T,? extends U> function,
                                                     Comparator<? super U> comparator)

Get a Collector that calculates the MIN() function.

allMatch

public static Collector<Boolean,?,Boolean> allMatch()

Get a Collector that calculates the ALL() function.

allMatch

public static <T> Collector<T,?,Boolean> allMatch(Predicate<? super T> predicate)

Get a Collector that calculates the ALL() function.

anyMatch

public static Collector<Boolean,?,Boolean> anyMatch()

Get a Collector that calculates the ANY() function.

anyMatch

public static <T> Collector<T,?,Boolean> anyMatch(Predicate<? super T> predicate)

Get a Collector that calculates the ANY() function.

noneMatch

public static Collector<Boolean,?,Boolean> noneMatch()

Get a Collector that calculates the NONE() function.

noneMatch

public static <T> Collector<T,?,Boolean> noneMatch(Predicate<? super T> predicate)

Get a Collector that calculates the NONE() function.

mode

public static <T> Collector<T,?,Optional<T>> mode()

Get a Collector that calculates the MODE() function.

rank

public static <T extends Comparable<? super T>> Collector<T,?,Optional<Long>> rank(T value)

Get a Collector that calculates the RANK() function given natural ordering.

rank

public static <T> Collector<T,?,Optional<Long>> rank(T value,
                                                     Comparator<? super T> comparator)

Get a Collector that calculates the RANK() function given a specific ordering.

rankBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Long>> rankBy(U value,
                                                                                       Function<? super T,? extends U> function)

Get a Collector that calculates the derived RANK() function given natural ordering.

rankBy

public static <T,U> Collector<T,?,Optional<Long>> rankBy(U value,
                                                         Function<? super T,? extends U> function,
                                                         Comparator<? super U> comparator)

Get a Collector that calculates the derived RANK() function given a specific ordering.

denseRank

public static <T extends Comparable<? super T>> Collector<T,?,Optional<Long>> denseRank(T value)

Get a Collector that calculates the DENSE_RANK() function given natural ordering.

denseRank

public static <T> Collector<T,?,Optional<Long>> denseRank(T value,
                                                          Comparator<? super T> comparator)

Get a Collector that calculates the DENSE_RANK() function given a specific ordering.

denseRankBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Long>> denseRankBy(U value,
                                                                                            Function<? super T,? extends U> function)

Get a Collector that calculates the derived DENSE_RANK() function given natural ordering.

denseRankBy

public static <T,U> Collector<T,?,Optional<Long>> denseRankBy(U value,
                                                              Function<? super T,? extends U> function,
                                                              Comparator<? super U> comparator)

Get a Collector that calculates the derived DENSE_RANK() function given a specific ordering.

percentRank

public static <T extends Comparable<? super T>> Collector<T,?,Optional<Double>> percentRank(T value)

Get a Collector that calculates the PERCENT_RANK() function given natural ordering.

percentRank

public static <T> Collector<T,?,Optional<Double>> percentRank(T value,
                                                              Comparator<? super T> comparator)

Get a Collector that calculates the PERCENT_RANK() function given a specific ordering.

percentRankBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<Double>> percentRankBy(U value,
                                                                                                Function<? super T,? extends U> function)

Get a Collector that calculates the derived PERCENT_RANK() function given natural ordering.

percentRankBy

public static <T,U> Collector<T,?,Optional<Double>> percentRankBy(U value,
                                                                  Function<? super T,? extends U> function,
                                                                  Comparator<? super U> comparator)

Get a Collector that calculates the derived PERCENT_RANK() function given a specific ordering.

median

public static <T extends Comparable<? super T>> Collector<T,?,Optional<T>> median()

Get a Collector that calculates the MEDIAN() function given natural ordering.

median

public static <T> Collector<T,?,Optional<T>> median(Comparator<? super T> comparator)

Get a Collector that calculates the MEDIAN() function given a specific ordering.

median

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>> median(Function<? super T,? extends U> function)

Get a Collector that calculates the MEDIAN() function given a specific ordering.

median

public static <T,U> Collector<T,?,Optional<U>> median(Function<? super T,? extends U> function,
                                                      Comparator<? super U> comparator)

Get a Collector that calculates the MEDIAN() function given a specific ordering.

medianBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>> medianBy(Function<? super T,? extends U> function)

Get a Collector that calculates the derived MEDIAN() function given natural ordering.

medianBy

public static <T,U> Collector<T,?,Optional<T>> medianBy(Function<? super T,? extends U> function,
                                                        Comparator<? super U> comparator)

Get a Collector that calculates the derived MEDIAN() function given a specific ordering.

percentile

public static <T extends Comparable<? super T>> Collector<T,?,Optional<T>> percentile(double percentile)

Get a Collector that calculates the PERCENTILE_DISC(percentile) function given natural ordering.

percentile

public static <T> Collector<T,?,Optional<T>> percentile(double percentile,
                                                        Comparator<? super T> comparator)

Get a Collector that calculates the PERCENTILE_DISC(percentile) function given a specific ordering.

percentile

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<U>> percentile(double percentile,
                                                                                        Function<? super T,? extends U> function)

Get a Collector that calculates the PERCENTILE_DISC(percentile) function given a specific ordering.

percentile

public static <T,U> Collector<T,?,Optional<U>> percentile(double percentile,
                                                          Function<? super T,? extends U> function,
                                                          Comparator<? super U> comparator)

Get a Collector that calculates the PERCENTILE_DISC(percentile) function given a specific ordering.

percentileBy

public static <T,U extends Comparable<? super U>> Collector<T,?,Optional<T>> percentileBy(double percentile,
                                                                                          Function<? super T,? extends U> function)

Get a Collector that calculates the derived PERCENTILE_DISC(percentile) function given natural ordering.

percentileBy

public static <T,U> Collector<T,?,Optional<T>> percentileBy(double percentile,
                                                            Function<? super T,? extends U> function,
                                                            Comparator<? super U> comparator)

Get a Collector that calculates the derived PERCENTILE_DISC(percentile) function given a specific ordering.

Class Agg

Constructor Summary

Constructors

Method Summary

Methods

Methods inherited from class java.lang.Object

Constructor Detail

Agg

Method Detail

count

countDistinct

countDistinctBy

sum

sum

avg

avg

min

min

min

min

minBy

minBy

max

max

max

max

maxBy

maxBy

allMatch

allMatch

anyMatch

anyMatch

noneMatch

noneMatch

mode

rank

rank

rankBy

rankBy

denseRank

denseRank

denseRankBy

denseRankBy

percentRank

percentRank

percentRankBy

percentRankBy

median

median

median

median

medianBy

medianBy

percentile

percentile

percentile

percentile

percentileBy

percentileBy