>I have a table with a datetime field. I would like to count the number of records that exist per year to get a result set something like this:
>
>
>count year
>
>42 1994
>67 1995
> .
> .
> .
>234 2005
>42 2006
>
>
>Any assistance would be appreciated.
>
>Thanks,
>Einar
SELECT YEAR(datetimefield) ,count(*) from table group by YEAR(datetimefield)