Percentage of Total Occurances

From: Adam Sherman <adam(at)tritus(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Percentage of Total Occurances
Date: 2003-04-15 14:53:52
Message-ID: 6790000.1050418432@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message rute solipa 2003-04-15 15:52:07 help need it
Previous Message Bruce Momjian 2003-04-15 14:23:30 Re: [PERFORM] Yet Another (Simple) Case of Index not used