Implementation of having count with group by in java 8

Question

I am looking for an implementation of group by, having and then filter based on count in lambda expressions.

select COUNT(employee_id), department_id  from employee
GROUP BY department_id
HAVING COUNT(employee_id) > 1

Is there any simple implementation of achieving this using lambda expressions.

Alexis C. · Accepted Answer · 2016-03-28 11:15:07Z

14

You can combine the groupingBy collector, with counting() and collectingAndThen:

import static java.util.stream.Collectors.collectingAndThen;
import static java.util.stream.Collectors.counting;
import static java.util.stream.Collectors.groupingBy;

...

Map<Long, Long> map = 
    employees.stream()
             .collect(collectingAndThen(groupingBy(Employee::getDeptId, counting()), 
                                        m -> { m.values().removeIf(v -> v <= 1L); return m; }));

Note that here is no guarantee on the mutability of the map returned by groupingBy, so you can use the overloaded version and supply a concrete mutable instance if you want.

answered Mar 28, 2016 at 11:15

Alexis C.

94.3k22 gold badges173 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Implementation of having count with group by in java 8

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related