Postgres Pro
Downloads
Home   >   mailing lists

statistics using SQL - Mailing list pgsql-sql

From Oleg Bartunov
Subject statistics using SQL
Date
Msg-id Pine.GSO.3.96.SK.1000305225834.460G-100000@ra
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Left Join
Next
From: David Celjuska
Date:
Subject: database with 1000000 rows is very slow