SQL request

[Claudius Sailer]

Am 13. Aug 2005 um 13:45 Uhr schrieb Ivan Smahin:

> Hello Thierry,
>
> Saturday, August 13, 2005, 2:33:57 PM, you wrote:
>
> TN> Hello,
>
>
> TN> Besides, I would like to collect the number of 'nom' for every
> TN> recording.
>
> TN> "SELECT DISTINCT nom, COUNT(nom) FROM individus WHERE condition  
> ORDER
> TN> BY nom"
> TN> or all my other requests don't work.
>
> You could try something like this:
> select count( distinct nom )...

I would say

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

or

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

bye


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 5.5.5/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]