Stupid SQL Question:

Поиск
Список
Период
Сортировка
От shawn everett
Тема Stupid SQL Question:
Дата
Msg-id Pine.LNX.4.30.0011141612570.9125-100000@alder.pgweb.com
обсуждение исходный текст
Ответы Re: Stupid SQL Question:
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Philip Hallstrom
Дата:
Сообщение: Re: [ANNOUNCE] [RELEASE ANNOUNCEMENT] v7.0.3 *Final* now Available
Следующее
От: "Valter Mazzola"
Дата:
Сообщение: eRserver.com Replication Server beta not available !?