From: mallah@trade-india.com
To: adam@tritus.ca
Cc: pgsql-sql@postgresql.org
Subject: Re: Percentage of Total Occurances
Date: Wed, 16 Apr 2003 01:11:08 +0530 (IST)
Message-ID: <1608.219.65.253.230.1050435668.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <30270000.1050433172@saturn>
References: <6790000.1050418432@saturn>
<1177.219.65.253.230.1050426637.squirrel@mail.trade-india.com>
<30270000.1050433172@saturn>
well if everything in a single query is that imp u may do this subselect:
select answer_id , 1.0*count(*) / (select count(*) from polls where poll_id = ?)
from polls where poll_id = ? group by answer_id ;
and if u need to trim the trailing digits after decimal
do to_char(value , '99.99')
since u have not provided any sample data i cann't test it.
> On 04/15/03 22:40:37 +0530 mallah@trade-india.com wrote:
>
>>> I have a table being used for poll results:
>>>
>>> id
>>> poll_id
>>> question_id
>>> answer_id
>>> datestamp
>>>
>>> I what to figure out the percentage or respondants that gave each answer. This is based on
>>> occurance rather than values.
>>
>>
select answer_id , 1.0*count(*) / (select count(*) from polls where poll_id = ?)
from polls where poll_id = ? group by answer_id ;
>>
>> gives number of response of each answer
>>
>> total_response = select count(*) from polls where poll_id = ?
>>
>> getting %age shud be trivial.
>>
>> Dunno if i missed your question .
>
> I'm looking to do everything in a single query.
>
> And get something like:
>
> answer_id -> percentage
>
> Thanks,
>
> A.
>
> --
> Adam Sherman
> Tritus CG Inc.
> http://www.tritus.ca/
> +1 (613) 797-6819
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you
> checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.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: mallah@trade-india.com, adam@tritus.ca
Subject: Re: Percentage of Total Occurances
In-Reply-To: <1608.219.65.253.230.1050435668.squirrel@mail.trade-india.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