On 29 Feb, 06:36, stockton <simon.stock...@baesystems.com> wrote:
> > Not tested:
> > SELECT ID_2, DAY, COUNT(*) AS COUNT, DISTINCT(MONTH) FROM `TABLE` GROUP
> > BY `ID_2`, `DAY` HAVING COUNT > 1
>
> Unfortunately this doesn't work!
>
> Any other ideas?

You don't deserve more help when you post things like "this doesn't
work" without explaining precisely what doesn't work with it. But I'm
feeling generous today.

Do you actually need the count, or was it only there to detect the
multiple rows?