mysql 按某字段分组后，对剩余字段去重

最新推荐文章于 2025-07-15 09:59:21 发布

原创最新推荐文章于 2025-07-15 09:59:21 发布 · 906 阅读

1 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

select receiver_code                        "receiver_code",

       count(receiver_name)                 "receiver_name数量",
       count(distinct receiver_name)        "receiver_name去重后数量",
       group_concat(distinct receiver_name separator '、') "receiver_name去重后集合",

       count(godown_out_no)                 "godown_out_no数量",
       count(distinct godown_out_no)        "godown_out_no去重后数量",
       group_concat(distinct godown_out_no separator '、') "godown_out_no去重后集合"
from wms_wave_item
group by receiver_code