From: Adam Sherman <adam@tritus.ca>
To: pgsql-sql@postgresql.org
Subject: Percentage of Total Occurances
Date: Tue, 15 Apr 2003 10:53:52 -0400
Message-ID: <6790000.1050418432@saturn> (raw)
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.
I want to be able to figure it out for a single (poll_id,qustion_id)
combination and also for multiple questions.
Thanks for your help,
A.
--
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819
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: adam@tritus.ca
Subject: Re: Percentage of Total Occurances
In-Reply-To: <6790000.1050418432@saturn>
* 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