Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E33DB9FA372 for ; Mon, 6 Nov 2006 15:26:13 -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 22870-10 for ; Mon, 6 Nov 2006 15:26:10 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id DCA929FA103 for ; Mon, 6 Nov 2006 15:26:09 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id t13so1081138wxc for ; Mon, 06 Nov 2006 11:26:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:in-reply-to:references:date:message-id:user-agent:mime-version:content-type:content-transfer-encoding:x-virus-scanned; b=OH3syIB3thj+xu8Qtk7pvIGhKiMDYpm16pvYWjcB2yta3oqGQvweW5+p2GKw0clSsPmRG7qshyU3S8Ejtyobdi+nGppPKWym1t/pnYifRGPMNNB74EumFVf9hJwlB6sAC7sNMplz7RPXReLCPZFAJoryGtQbX5MBkSz4lXy9WF4= Received: by 10.90.105.20 with SMTP id d20mr2483489agc.1162841169055; Mon, 06 Nov 2006 11:26:09 -0800 (PST) Received: from strongwill.g2ctech ( [201.86.1.229]) by mx.google.com with ESMTP id 27sm9392609wrl.2006.11.06.11.26.07; Mon, 06 Nov 2006 11:26:08 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by strongwill.g2ctech (Postfix) with ESMTP id 3F801E5DF9; Mon, 6 Nov 2006 17:26:04 -0200 (BRDT) Received: from strongwill.g2ctech ([127.0.0.1]) by localhost (strongwill.g2ctech [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 27834-01-5; Mon, 6 Nov 2006 17:26:03 -0200 (BRDT) Received: from jupiter.g2ctech (unknown [201.22.19.106]) by strongwill.g2ctech (Postfix) with ESMTP id E2D21E5ED0; Mon, 6 Nov 2006 17:26:02 -0200 (BRDT) Received: by jupiter.g2ctech (Postfix, from userid 1000) id 1C0591247B4; Mon, 6 Nov 2006 17:25:37 -0200 (BRDT) From: Jorge Godoy To: "Raghuraman K" Cc: Subject: Re: Distribution of results In-Reply-To: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft> (Raghuraman K.'s message of "Wed\, 1 Nov 2006 21\:47\:44 +0530") References: <93F0E3CFC1ABB646B8808894FC7CDD25067221E2@azindbaex01.aztec.soft> Date: Mon, 06 Nov 2006 17:25:37 -0200 Message-ID: <87r6wgidhq.fsf@gmail.com> User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Virus-Scanned: amavisd-new at g2ctech.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.415 tagged_above=0 required=5 tests=BAYES_00, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY, RCVD_IN_SORBS_SOCKS, SPF_PASS X-Spam-Level: X-Archive-Number: 200611/80 X-Sequence-Number: 26732 "Raghuraman K" 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