On 2011-08-31 18:14, ncreamer wrote:
The base_tutorial provides an query example where you first count a subset of
data (number of patients with ptsd) and divide that by the total number of
patients with any diagnosis.
Is there a way to - using this same patient example - query for the
percentages of the whole for *all* diagnosis?
SELECT COUNT (*) AS "Total PTSD Patients" FROM "Patients" WHERE
"Diagnosis"='PTSD';
The syntax is a bit different from what I'm used to, but I think you
want "GROUP BY", as in:
SELECT COUNT (*) AS "Total PTSD Patients" FROM "Patients" GROUP BY
"Diagnosis";
/Ulrik
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
