Subject SQL with Extract in Group By Clause
Author 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.