摘要：
select * from(select id, idkey,ROW_NUMBER() over(partition by id order by idkey desc)as num from Sample) as aawhere 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 aawhere aa.num<=5 order by id 阅读全文
|