设置开窗函数修改排序问题

guoyuji

2024-05-20 daf6022316cff7b3772c9fa3614043a94309205f

设置开窗函数修改排序问题

 north-glass-erp/src/main/resources/mapper/sd/CustomerMapper.xml

@@ -167,10 +167,22 @@
            b.salesman
        from
            sd.customer as a
        left join (select o.project,o.salesman_id,o.salesman,o.customer_id
                   from sd.order as o
                   group by o.customer_id
                   order by o.id desc) as b
        left join (SELECT
                       t.*
                   FROM
                       (
                           SELECT
                               ROW_NUMBER() over ( PARTITION BY o.customer_id ORDER BY o.id DESC ) AS rn,
                               o.id,
                               o.project,
                               o.salesman_id,
                               o.salesman,
                               o.customer_id
                           FROM
                               sd.ORDER AS o
                       ) t
                   WHERE
                       rn = 1) as b
        on a.id = b.customer_id

    </select>