mysql 问题
mysql 用sum()函数求和 怎么会出现-1的值??在线等
SELECT
hospital_name,
GROUP_CONCAT(
DISTINCT statistics_date
ORDER BY
statistics_date
) AS new_date,
GROUP_CONCAT(
table_count
ORDER BY
statistics_date
),
GROUP_CONCAT(
all_date
ORDER BY
statistics_date
)
FROM
(
SELECT
a.hospital_name,
statistics_date,
count(b.table_name) AS table_count,
sum(b.count) AS all_date
FROM
statistics_log b
LEFT JOIN hospital a ON b.hospital_code = a.hospital_code
WHERE
statistics_date BETWEEN '2017-02-14'
AND '2017-02-20'
GROUP BY
a.hospital_name,
statistics_date
) aa
GROUP BY
hospital_name
LIMIT 0,
10
这是我的SQL