From: imad <immaad@gmail.com>
To: Raghuraman K <raghuramank@aztecsoft.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Distribution of results
Date: Tue, 7 Nov 2006 00:43:58 +0500
Message-ID: <1f30b80c0611061143j15ecfe47wfe4348fb3119d338@mail.gmail.com> (raw)
In-Reply-To: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
References: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
What else do you want to know about it? (keeping in mind the example you
gave)
Because, apparently this is just a matter of min and max.
--Imad
On 11/1/06, Raghuraman K <raghuramank@aztecsoft.com> wrote:
>
> 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?
>
> Regards,
>
> Raghu
>
> The information contained in, or attached to, this e-mail, contains
> confidential information and is intended solely for the use of the
> individual or entity to whom they are addressed and is subject to legal
> privilege. If you have received this e-mail in error you should notify the
> sender immediately by reply e-mail, delete the message from your system and
> notify your system manager. Please do not copy it for any purpose, or
> disclose its contents to any other person. The views or opinions presented
> in this e-mail are solely those of the author and do not necessarily
> represent those of the company. The recipient should check this e-mail and
> any attachments for the presence of viruses. The company accepts no
> liability for any damage caused, directly or indirectly, by any virus
> transmitted in this email.
>
> www.aztecsoft.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: immaad@gmail.com, raghuramank@aztecsoft.com
Subject: Re: Distribution of results
In-Reply-To: <1f30b80c0611061143j15ecfe47wfe4348fb3119d338@mail.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