Stupid SQL Question:
shawn everett <everett@pgweb.com>
From: shawn everett <everett@pgweb.com>
To: <pgsql-general@postgresql.org>
Date: 2000-11-15T00:18:39Z
Lists: pgsql-general
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