Posted by daoud97@yahoo.com on 06/02/06 13:30

markc600@hotmail.com schreef:

> 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'

mmm very interresting. Thanks

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

[Reply to this message]