gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Statistics


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Statistics
Date: Sat, 9 Feb 2013 00:00:40 +0100
User-agent: Mutt/1.5.21 (2010-09-15)

On Fri, Feb 08, 2013 at 02:28:31PM +0000, Vaibhav Banait wrote:

> How do I know how many patients I have seen in a day, month,

Which one ?   Or maybe you need to be a bit more specific
which time ranges you want to aggregate and which you want
to compare.

> or last year

select count(1)
from dem.identity d_i
where
        d_i.pk in (
                select fk_patient from clin.encounter
                where
                        fk_type in (select pk from clin.encounter_type where 
description in ('list', 'of', 'interesting', 'types')
                                and
                        started between 'year-01-01' and 'year-12-31'
        )
;

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



reply via email to

[Prev in Thread] Current Thread [Next in Thread]