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 or flat)
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


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-2014 The PostgreSQL Global Development Group