sql 分组后取排序第一条数据

小七夕 1年前 ⋅ 3988 阅读

SELECT * FROM (
SELECT *

-- ROW_NUMBER() over(partition by 字段order by 字段 ) as NEWINDEX
,ROW_NUMBER() over(partition by barCode order by inOutWireTime ) as NEWINDEX
FROM CK_WireDetailed where barCode like '%2022-09-26_5%'
) t
where t.NEWINDEX = 1


注意:本文归作者所有,未经作者允许,不得转载

全部评论: 0

    我有话说: