From: | Rodrigo De León <rdeleonp(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com> |
Subject: | Re: group by day |
Date: | 2007-05-24 19:45:47 |
Message-ID: | a55915760705241245q521967e1rfc46d7639ebb8bc2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 5/24/07, Edward W. Rouse <erouse(at)comsquared(dot)com> wrote:
>
>
> I have an audit table that I am trying to get a count of the number of
> distinct entries per day by the external table key field. I can do a
>
> select count(distinct(id)) from audit where timestamp >= '01-may-2007'
>
> and get a total count. What I need is a way to group on each day and get a
> count per day such that the result would be something like
>
> date count
> 01-may-2007 107
> 02-may-2007 215
> 03-may-2007 96
> 04-may-2007 0
>
>
> I would prefer the 0 entries be included but can live without them. Thanks.
>
> Oh, postgres 7.4 by the way.
>
>
>
> Edward W. Rouse
>
> ComSquared Systems, Inc.
>
> 770-734-5301
SELECT TIMESTAMP, COUNT(DISTINCT(ID))
FROM AUDIT
GROUP BY TIMESTAMP
ORDER BY TIMESTAMP
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-05-25 08:08:31 | Re: group by day |
Previous Message | A. Kretschmer | 2007-05-24 19:42:42 | Re: group by day |