Posted by Jerry Stuckle on 04/13/06 16:04

Arjen wrote:
> Arjen 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

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]