Given this data 

```
id  Name        group           

1   Jhon        001

2   Paul        002

3   Mary        001

```

How can I get the duplicates values showing all the fields? The duplicate is only on group, id and name won't be duplicates. 

Should end up looking like one of those (any would be valid):

```
:::::::::::::::::::::::::::::::::::::::::::::::
group  count values

001     2     1,3

:::::::::::::::::::::::::::::::::::::::::::::::
id  name        group
1   Jhon        001
3   Mary        001

```

I tried with

```
SELECT
    group, COUNT(*)
FROM
    people
GROUP BY
    group
HAVING 
    COUNT(*) > 1

```

But if I try to add id and name to the group by, it won´t find any duplicate. 

Thanks in advance.