calculating percentages - Mailing list pgsql-sql

From Thomas Good
Subject calculating percentages
Date
Msg-id Pine.LNX.3.96.990712094714.3092A-100000@admin.nrnet.org
Whole thread Raw
Responses Re: [SQL] calculating percentages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi.

I am trying to do outcome studies on pt before and after treatment
recidivism rates...and having some trouble calculating percentages.

How does one do this:   SELECT (current_value/target) * 100;
in postgres?  

Cheers - and thanks,
Tom

------- North Richmond Community Mental Health Center -------

Thomas Good                                   MIS Coordinator
Vital Signs:                  tomg@ { admin | q8 } .nrnet.org                                         Phone:
718-354-5528                                          Fax:   718-354-5056                               
 
/* Member: Computer Professionals For Social Responsibility */ 



pgsql-sql by date:

Previous
From: John Bowden
Date:
Subject: SQL: Getting table structure
Next
From: "Tiberiu Craciun"
Date:
Subject: Re: [SQL] calculating percentages