34,576
社区成员
发帖
与我相关
我的任务
分享
select a.* from tablename a ,
(select top 5 订单号,min(编号) as ID from tablename group by 订单号 order by min(编号) desc) as b
where a.订单号=b.订单号 and a.编号=b.ID
select top 5 [编号],[订单号],[其它] from
(
SELECT ROW_NUMBER()OVER(PARTITION BY [订单号] ORDER BY [编号])RN,[编号],[订单号],[其它] FROM 表
)T
WHERE
T.RN=1
ORDER BY
T.[订单号]
你参考一下,看是不是这样子