Postgres Pro
Downloads
Home   >   mailing lists

Percentage of Total Occurances - Mailing list pgsql-sql

From Adam Sherman
Subject Percentage of Total Occurances
Date
Msg-id 6790000.1050418432@saturn
Whole thread Raw
Responses Re: Percentage of Total Occurances  (<mallah@trade-india.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PERFORM] [GENERAL] Yet Another (Simple) Case of Index not used
Next
From: pginfo
Date:
Subject: changing column size and type.