count query

[Guest_imported]

I want to sum my members by country
I did something like this....but it doesnt work...

select count(id)
from orderrow
where (id) IN
(select distinct country
from orderrow)

 

[grega]

Something like ...

select count(*), country
from orderrow
group by country

... should work

Greg.

 

[Guest_imported]

THANKS!!!