SQL request

Ivan Smahin IvanSmahin at public.kherson.ua
Sat Aug 13 14:45:10 CDT 2005


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 )...



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua



More information about the Valentina mailing list