calculating percentages

From: Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
To: "PostgreSQL::SQL List" <pgsql-sql(at)postgreSQL(dot)org>
Subject: calculating percentages
Date: 1999-07-12 13:50:15
Message-ID: Pine.LNX.3.96.990712094714.3092A-100000@admin.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 */

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 1999-07-12 14:50:27 Re: [SQL] calculating percentages
Previous Message John Bowden 1999-07-12 13:35:53 SQL: Getting table structure