SELECT
SKU_LIST AS sku,
GROUP_CONCAT( DISTINCT develop_department ) AS developDepartment
FROM
send_sku_download
WHERE
EXPRESS_TIME BETWEEN CONCAT('2024-07-01', ' 00:00:00' )
AND CONCAT( '2024-07-01', ' 23:59:59' )
GROUP BY
SKU_LIST
GROUP_CONCAT函数就可以实现。
这里假如根据SKU_LIST分组,develop_department 不希望参与分组,那就直接用逗号隔开。不用参与group by