>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)