| Subject | SQL with Extract in Group By Clause |
|---|---|
| Author | Lou |
| Post date | 2004-08-03T21:02:55Z |
Hello.
Is it possible do use the Extract function to Group-By in a query?
I periodicaly have a need to report summary totals over several
months and the only way that seems logical is to group by Extract
(Year from date), Extracte (month from date), sum(value) etc....
I am currently only using FB1.0x FB 1.5 is in my near future for
this project. Will D/l and try on FB 1.51 first chance I get.
-Lou
Is it possible do use the Extract function to Group-By in a query?
I periodicaly have a need to report summary totals over several
months and the only way that seems logical is to group by Extract
(Year from date), Extracte (month from date), sum(value) etc....
I am currently only using FB1.0x FB 1.5 is in my near future for
this project. Will D/l and try on FB 1.51 first chance I get.
-Lou