SQL request

[Thierry NAUZE]

Le 14 août 05 à 10:11, Claudius Sailer a écrit :

> I would say
>
> SELECT nom, count(*) from dividus WHERE condition GROUP BY nom  
> ORDER BY nom?
>

Thanks Claudius.

The first makes exactly what I want.
I have not yet tried the other one.

> or
>
> SELECT nom, count(*) from dividus WHERE condition ORDER BY nom  
> GROUP BY nom?
>

Bye,

--
Thierry NAUZE        Saint-Denis de la Réunion