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
mysql 按某字段分组后,对剩余字段去重
最新推荐文章于 2024-07-03 03:23:10 发布