Re: Stupid SQL Question:

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
>