|
|
Posted by daoud97@yahoo.com on 06/02/06 11:53
other example to help you :
Mat Dur
16030 d
16030 i
31217 i
10000 d
12000 i
10000 d
31217 d
35000 d
36000 i
35000 d
35000 i
i need this result :
10000 d
Now, 35000 have one 'i' in 'Dur', so i don't need it.
daoud97@yahoo.com schreef:
> markc...@hotmail.com schreef:
>
> > Is this what you want?
> >
> >
> > SELECT Mat,
> > Dur
> > FROM MAND
> > GROUP BY Mat,Dur
> > HAVING COUNT(*)=2
>
> No.
>
> When i group by 'Mat' i need to filter by 'Mat' having only 'd' in
> 'Dur'. I d'ont want Mat with 'i' in Dur.
Navigation:
[Reply to this message]
|