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
注意:本文归作者所有,未经作者允许,不得转载