Posted by <dev> on 07/06/05 17:13

<dev> wrote in message
news:42cba697$0$14626$e4fe514c@dreader13.news.xs4all.nl...
> hey all,
>
> I have a group by problem in mysql made in php code
>
> if I have this table
>
> table TEST
>
> colunms:
>
> ID
> SID
> email
> DATE
>
> and this data
>
> ID SID EMAIL DATE
>
> 1 3 A@ BLA
> 2 3 A@ BLA
> 3 1 S@ BLA
> 4 1 S@ BLA
> 5 5 A@ BLA
> 6 1 A@ BLA
> 7 1 A@ BLA
>
> and i do this query
>
>
> SELECT count(*) AS C, EMAIL, SID FROM TEST
> WHERE SID = SID GROUP BY email ORDER BY C DESC
>
> i get
>
> C EMAIL SID
> 2 A@ 3
> 2 S@ 1
> 1 A@ 5
>
>
>
> BUT I WANT TO GET THIS
>
> C EMAIL SID
> 2 A@ 3
> 2 A@ 1
> 2 S@ 1
> 1 A@ 5
>
> i want to delete all the more then 1 email with the same SID from the
> table but the group by is not correct..
> anybody help?
>
>
> Cheers,
>
> D
>
>
>

??

• Next in forum: Re: Re: Don't unset that variable you need globally
• Prev in forum: Re: attach imagejpeg to email
• Thread view: Re: sql statement group by?

[Reply to this message]