|
|
Posted by daoud97@yahoo.com on 06/02/06 12:37
daoud97@yahoo.com schreef:
> markc600@hotmail.com schreef:
>
> > SELECT Mat,
> > 'd' AS Dur
> > FROM MAND
> > GROUP BY Mat
> > HAVING COUNT(*)=2 AND COUNT(DISTINCT Dur)=1
>
> Sorry, it's not correct :
>
> if i insert
>
> 36000 i
> 36000 i
>
> and apply your SQL, i have some result like :
>
> 10000 d
> 16030 d
> 31217 d
> 36000 d (????)
>
> perhaps, i d'ont expline vers well !
I will try to expline more :
this is the table with groups:
Mat Dur
16030 d
16030 i
31217 i
31217 d
31217 d
31217 d
10000 d
10000 d
10000 d
35000 d
I'am interested only by the 2 groups : 1000 and 35000 because the
haven't any 'i' in the colonn Dur.
Navigation:
[Reply to this message]
|