|
|
Posted by daoud97@yahoo.com on 06/02/06 12:32
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 !
Navigation:
[Reply to this message]
|