SELECT YEAR(DatetimeField) AS year, COUNT(*) 
  FROM mytable GROUP BY YEAR(DatetimeField)

>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