Thread: statistics using SQL

statistics using SQL

From
Oleg Bartunov
Date:
Hi.

I'm looking for elegant way to do some simple statistics
using SQL. Actually I want to get percents in query like

select region, district, count(*) as cnt from geo group by region,district;
Regards,
    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83