How to GROUP results BY month

Поиск
Список
Период
Сортировка
От Oliveiros Cristina
Тема How to GROUP results BY month
Дата
Msg-id 009b01c8e674$13b716e0$ec5a3d0a@marktestcr.marktest.pt
обсуждение исходный текст
Ответ на Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: How to GROUP results BY month
Re: How to GROUP results BY month
Re: How to GROUP results BY month
Re: How to GROUP results BY month
Список pgsql-sql
Howdy, all,

I have a problem.

I have a table which one of the fields is of type date.

I need to obtain the totals of the other fields in a  by-month basis
IS there any easy way to do this using the GROUP BY or any other construct?

Thanks in advance for your kind help

Best,
Oliveiros


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Rollback in Postgres
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How to GROUP results BY month