[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