Posted by markc600 on 06/02/06 13:12

The problem is I'm trying to guess your business rules


SELECT Mat,
MAX(Dur) AS Dur
FROM MAND
GROUP BY Mat
HAVING COUNT(*)>1 AND COUNT(DISTINCT Dur)=1
AND MAX(Dur)='d'

• Next in forum: Re: HAVING prob !
• Prev in forum: Re: HAVING prob !
• Thread view: Re: HAVING prob !

[Reply to this message]