From: | Michael Fork <mfork(at)toledolink(dot)com> |
---|---|
To: | shawn everett <everett(at)pgweb(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stupid SQL Question: |
Date: | 2000-11-15 00:49:18 |
Message-ID: | Pine.BSI.4.21.0011141946530.26240-100000@glass.toledolink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try these queries...
SELECT injdate, outcome, count(outcome) FROM safety GROUP BY
injdate,outcome;
or
SELECT outcome, count(outcome) FROM safety WHERE injdate='2000-11-14'
GROUP BY outcome;
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Tue, 14 Nov 2000, shawn everett wrote:
> I have a table defined as follows:
>
> CREATE TABLE safety (
> sid SERIAL,
> side INTEGER,
> InjDate DATE,
> InjType INTEGER,
> Outcome INTEGER,
> PRIMARY KEY (sid)
> );
>
> What I'm trying to generate is a list of all outcomes and how many of each
> that occured for a particular range of dates.
>
> This works but doesn't do dates:
>
> SELECT outcome,count(outcome) from safety
> GROUP BY outcome;
>
> How do I incorporte dates into this query.
>
> Adding a WHERE clause to the query doesn't work for example:
>
> SELECT outcome,count(outcome) from safety
> GROUP BY outcome
> WHERE InjDate='2000-11'14';
>
> Any tips or advice would be apreciated.
>
> Shawn
>
From | Date | Subject | |
---|---|---|---|
Next Message | shawn everett | 2000-11-15 00:55:55 | Re: Stupid SQL Question: |
Previous Message | Jonathan Ellis | 2000-11-15 00:47:55 | Re: Stupid SQL Question: |