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
==================
Navigation:
[Reply to this message]
|