sql server 2008 - how to using select datepart -

i have sql query this

select top 1      row_number() on (order column_date desc) rowid, *       table_report       column_date = datepart(year,date) 

please correct if i'm wrong. want to take year datetime , select top 1 row number year

you can select first row (in order provided) every year adding partition windowing function, , filter on first row of each year:

select * (     select row_number() on       (partition datepart(year,date) order column_date desc) rowid,      *      table_report  ) x rowid = 1;