opt: sql改造其他模块改造11

linwei

2026-04-02 ee64f2a1dc1371b430257ffb2224f691600b3cf2

opt: sql改造其他模块改造11

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdManageDevicePayloadMapper.xml

@@ -25,8 +25,13 @@
            *
        from
            ja_gd_manage_device_payload
        where is_deleted = 0
        group by name
        where id in (
            select max(id)
            from ja_gd_manage_device_payload
            where is_deleted = 0
            group by name
        )
          and is_deleted = 0
    </select>