Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 13D4C9FA372
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 15:44:05 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 28463-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 15:44:00 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169])
	by postgresql.org (Postfix) with ESMTP id CE0CF9FA1DB
	for <pgsql-sql@postgresql.org>; Mon,  6 Nov 2006 15:43:59 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so826389ugf
	for <pgsql-sql@postgresql.org>; Mon, 06 Nov 2006 11:43:58 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=EjiJqMotlRukqOx7RVWVtPcWoNZqHAfYuySCLING8OngvFuWw6mkxwSMcASt1PQN7blXoo6mF7T5VneDRgVVuFJhw6PJ1PLM/bd7JEGuWXtN/tqM57UpqHbWliXbFh3gforNVPJnGHuk+RQe+FGDE4xjVnSdoQfrFTNRNthiBZQ=
Received: by 10.82.179.9 with SMTP id b9mr1370666buf.1162842238161;
	Mon, 06 Nov 2006 11:43:58 -0800 (PST)
Received: by 10.82.161.3 with HTTP; Mon, 6 Nov 2006 11:43:58 -0800 (PST)
Message-ID: <1f30b80c0611061143j15ecfe47wfe4348fb3119d338@mail.gmail.com>
Date: Tue, 7 Nov 2006 00:43:58 +0500
From: imad <immaad@gmail.com>
To: "Raghuraman K" <raghuramank@aztecsoft.com>
Subject: Re: Distribution of results
Cc: pgsql-sql@postgresql.org
In-Reply-To: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_66713_23170734.1162842238047"
References: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/82
X-Sequence-Number: 26734

------=_Part_66713_23170734.1162842238047
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_66713_23170734.1162842238047
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What else do you want to know about it? (keeping in mind the example you gave)<br>
Because, apparently this is just a matter of min and max.<br>
<br>
--Imad<br>
<br><br><div><span class="gmail_quote">On 11/1/06, <b class="gmail_sendername">Raghuraman K</b> &lt;<a href="mailto:raghuramank@aztecsoft.com">raghuramank@aztecsoft.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div><font color="#000000" face="Arial" size="2">Hi,</font></div>
<div><font face="Arial" size="2"></font>&nbsp;</div>
<div><font face="Arial" size="2">&nbsp;&nbsp; I have a table like this: create
table(xyz char(10), answer number(4)).&nbsp; 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).&nbsp; Can anyone please help?</font></div>
<div><font face="Arial" size="2"></font>&nbsp;</div>
<div><font face="Arial" size="2">&nbsp;&nbsp; Regards,</font></div>
<div><font face="Arial" size="2"></font>&nbsp;</div>
<div><font face="Arial" size="2">Raghu</font></div></div>
<table><tbody><tr><td bgcolor="#ffffff"><font color="#000000"><br>
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.<br>
<br>
<a href="http://www.aztecsoft.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.aztecsoft.com</a><br>
</font></td></tr></tbody></table>
</blockquote></div><br>

------=_Part_66713_23170734.1162842238047--