Sqlerver2005+按照ID分组取前几条

select *  from
(select  id, idkey,ROW_NUMBER() over(partition by id order by idkey desc)
as num from Sample) as aa
where aa.num<=5 order by id