Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA65016 for ; Sun, 5 Mar 2000 15:00:42 -0500 (EST) (envelope-from oleg@sai.msu.su) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.9.3/8.9.3) with SMTP id XAA00639 for ; Sun, 5 Mar 2000 23:00:39 +0300 (GMT) Date: Sun, 5 Mar 2000 23:00:39 +0300 (GMT) From: Oleg Bartunov X-Sender: megera@ra To: pgsql-sql@postgreSQL.org Subject: statistics using SQL Message-ID: Organization: Sternberg Astronomical Institute (Moscow University) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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