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 posted on 2014-10-22 11:28 阅读( ...) 评论( ...)
本文共 234 字，大约阅读时间需要 1 分钟。
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转载于:https://www.cnblogs.com/lsyyx/p/4042658.html