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

  #3 (permalink)  
Old 02-29-2008
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