Tom Dawn - 1 year ago 103

MySQL Question

Answer Source

```
SELECT cid
FROM yourTable
GROUP BY cid
HAVING COUNT(*) - COUNT(DISTINCT pid) > 0
```

**Explanation:**

This query will identify `cid`

groups which have a `pid`

value appearing twice or more, for at least one `pid`

value. The logic in the `HAVING`

clause is that if all `pid`

are unique for a `cid`

group, then the expression will equal zero, otherwise it will be greater than zero.