Message-ID: <1177.219.65.253.230.1050426637.squirrel@mail.trade-india.com>
Date: Tue, 15 Apr 2003 22:40:37 +0530 (IST)
Subject: Re: Percentage of Total Occurances
From: <mallah@trade-india.com>
To: <adam@tritus.ca>
In-Reply-To: <6790000.1050418432@saturn>
References: <6790000.1050418432@saturn>
Importance: Normal
Cc: <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

> 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,count(*) from polls where poll_id =3D ?
group by answer_id ;

gives number of response of each answer

total_response =3D select count(*) from polls where poll_id =3D ?

getting %age shud be trivial.

Dunno if i missed your question .
>
> I want to be able to figure it out for a single (poll_id,qustion_id)  com=
bination and also for
> multiple questions.
>

sorry i do not get it.

> Thanks for your help,
>
> A.
>
>
> --
> Adam Sherman
> Tritus CG Inc.
> http://www.tritus.ca/
> +1 (613) 797-6819
>
>
> ---------------------------(end of broadcast)--------------------------- =
TIP 4: Don't 'kill -9'
> the postmaster


-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/