SELECT *
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY c.DEVICENO ORDER BY CREATETIME DESC) rn,
c.*
FROM KMS_CARD_SERVICE c)
WHERE rn = 1 ;
sql,排序后,取第一条数据
最新推荐文章于 2024-05-13 16:09:50 发布
SELECT *
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY c.DEVICENO ORDER BY CREATETIME DESC) rn,
c.*
FROM KMS_CARD_SERVICE c)
WHERE rn = 1 ;