Skip site navigation (1) Skip section navigation (2)

statistics using SQL

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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;


Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su,
phone: +007(095)939-16-83, +007(095)939-23-83

pgsql-sql by date

Next:From: David CeljuskaDate: 2000-03-05 20:11:02
Subject: database with 1000000 rows is very slow
Previous:From: Peter EisentrautDate: 2000-03-05 14:15:35
Subject: Re: [SQL] Left Join

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group