From: Jorge Godoy <jgodoy@gmail.com>
To: Raghuraman K <raghuramank@aztecsoft.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Distribution of results
Date: Mon, 06 Nov 2006 17:25:37 -0200
Message-ID: <87r6wgidhq.fsf@gmail.com> (raw)
In-Reply-To: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
References: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
"Raghuraman K" <raghuramank@aztecsoft.com> writes:
> Hi,
>
> I have a table like this: create table(xyz char(10), answer number(4)). There are a lot of rows in this table. I am looking at a query that will help me represent the distribution of data records based on the column answer. For example, we may take that the highest entry for answer column is 90 and the lowest is 2 and there are 1000 records. I am looking at a query that will tell how the 1000 records are distributed between the highest and lowest answer (in this case between 90 and 2). Can anyone please help?
>
I believe this isn't hard if you use a statistical function. You can have one
fairly quickly with PL/R.
--
Jorge Godoy <jgodoy@gmail.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jgodoy@gmail.com, raghuramank@aztecsoft.com
Subject: Re: Distribution of results
In-Reply-To: <87r6wgidhq.fsf@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox