Subject Re: Count Dates by Year
Author ra8009
Thank you very much Helen

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 04:25 AM 26/09/2004 +0000, you wrote:
>
> >I have a column that contains a date. I want to summarize the number
> >of dates per year. How can I accomplish this?
>
> Select extract(year from mydate), count(mydate)
> group by 1
>
> ./h