SELECT
downEntrustNo,
JSON_ARRAYAGG(
JSON_OBJECT(
'orderNo', documentNo,
'orderInfo', JSON_OBJECT(
'groupName', groupName,
'lineName', lineName,
'customerName', customerName,
'volume', volume,
'weight', weight
)
)
) AS orderList,
MAX(create_time) AS max_create_time,
avg(systemStatus) as systemStatus ,
GROUP_CONCAT(DISTINCT logisticName ORDER BY logisticName SEPARATOR ', ') AS logisticName,GROUP_CONCAT(DISTINCT lineName ORDER BY lineName SEPARATOR ', ') AS lineName
FROM *表名*
GROUP BY downEntrustNo
ORDER BY max_create_time DESC
LIMIT 10;
SQL查询列表分组实现
于 2024-06-14 11:41:11 首次发布