Thread: SELECT, GROUP BY & HAVING problem!
View Single Post

   
  #3 (permalink)  
Old 03-01-2008, 03:49 PM
stockton
 
Posts: n/a
Default Re: SELECT, GROUP BY & HAVING problem!
> 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?
Reply With Quote