Here is a mock table

```
MYTABLE ROWS
PKEY    1,2,3,4,5,6
COL1    a,b,b,c,d,d
COL2    55,44,33,88,22,33

```

I want to know which rows have duplicated COL1 values:

```
select col1, count(*)  
from MYTABLE
group by col1
having count(*) > 1

```

This returns :

```
b,2
d,2

```

I now want all the rows that contain b and d. Normally, I would use *where in* stmt, but with the count column, not certain what type of statement I should use?