Posted by Arjen on 04/13/06 16:09

Jerry Stuckle wrote:

>>> SELECT COUNT (id) GROUP BY name
>> Ehmm .... SELECT name, COUNT (id) FROM table ORDER BY name
> SELECT name, COUNT(id) FROM table GROUP BY name

AAARCH !!

Well u know what I mean :-)

Arjen

• Next in forum: Re: Duplicates
• Prev in forum: Re: Duplicates
• Thread view: Re: Duplicates

[Reply to this message]