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
Дата:
От: Valter Mazzola
Дата:
FAQ