| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | statistics using SQL |
| Date: | 2000-03-05 20:00:39 |
| Message-ID: | Pine.GSO.3.96.SK.1000305225834.460G-100000@ra |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Celjuska | 2000-03-05 20:11:02 | database with 1000000 rows is very slow |
| Previous Message | Peter Eisentraut | 2000-03-05 14:15:35 | Re: [SQL] Left Join |