Subject Re: [firebird-support] Count Dates by Year
Author Helen Borrie
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