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