[libreoffice-users] Re: BASE Query/Report

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: users+help@global.libreoffice.org
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