Stupid SQL Question:
От
shawn everett
Тема
Stupid SQL Question:
Дата
Msg-id
Pine.LNX.4.30.0011141612570.9125-100000@alder.pgweb.com
Список
Дерево обсуждения
Stupid SQL Question: shawn everett <everett@pgweb.com>
Re: Stupid SQL Question: Michael Fork <mfork@toledolink.com>
Re: Stupid SQL Question: shawn everett <everett@pgweb.com>
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
В списке pgsql-general по дате отправления
От: Philip Hallstrom
Дата: