mysql迁移，以前写的一个sql报错，
为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：```language
sql：
SELECT a.MONTH as date, SUM(b.total) AS count
FROM (
SELECT DATE_FORMAT(create_date, '%Y-%m') AS MONTH, SUM(sum) AS total
FROM (
SELECT create_date, DATE_FORMAT(create_date, '%Y-%m') AS MONTH
, COUNT(*) AS sum
FROM dmp_device_model
GROUP BY MONTH
) ddm
GROUP BY MONTH
) a
JOIN (
SELECT DATE_FORMAT(create_date, '%Y-%m') AS MONTH, SUM(sum) AS total
FROM (
SELECT create_date, DATE_FORMAT(create_date, '%Y-%m') AS MONTH
, COUNT(*) AS sum
FROM dmp_device_model
GROUP BY MONTH
) ddm
GROUP BY MONTH
) b
ON a.MONTH >= b.MONTH
GROUP BY a.MONTH
ORDER BY a.MONTH;
表：
insert into “SYSDBA”.“DMP_DEVICE_MODEL”(“ID”, “NAME”, “DEVICE_MAKER_ID”, “DEVICE_MAKER_NAME”, “DEVICE_TYPE_ID”, “DEVICE_TYPE_NAME”, “NETWORK_SYSTEM”, “AGREEMENT_TYPE”, “CREATER”, “CREATE_DATE”, “UPDATER”, “UPDATE_DATE”, “PRODUCT_KEY”, “PRODUCT_SECRET”, “OBJECT_LINKS”, “DOWNLINK_PATH”)
VALUES(<“ID”, BIGINT>, <“NAME”, VARCHAR(30)>, <“DEVICE_MAKER_ID”, BIGINT>, <“DEVICE_MAKER_NAME”, VARCHAR(30)>, <“DEVICE_TYPE_ID”, BIGINT>, <“DEVICE_TYPE_NAME”, VARCHAR(30)>, <“NETWORK_SYSTEM”, VARCHAR(20)>, <“AGREEMENT_TYPE”, VARCHAR(20)>, <“CREATER”, VARCHAR(30)>, <“CREATE_DATE”, TIMESTAMP(0)>, <“UPDATER”, VARCHAR(30)>, <“UPDATE_DATE”, TIMESTAMP(0)>, <“PRODUCT_KEY”, VARCHAR(255)>, <“PRODUCT_SECRET”, VARCHAR(255)>, <“OBJECT_LINKS”, VARCHAR(50)>, <“DOWNLINK_PATH”, VARCHAR(50)>);
SELECT
a.MONTH as date,
SUM(b.total) AS count
FROM
(
SELECT
DATE_FORMAT(create_date, '%Y-%m') AS MONTH,
SUM(sum) AS total
FROM
(
SELECT
create_date ,
DATE_FORMAT(create_date, '%Y-%m') AS MONTH,
COUNT(*) AS sum
FROM
dmp_device_model
GROUP BY
create_date,
DATE_FORMAT(create_date, '%Y-%m')
)
ddm
GROUP BY
DATE_FORMAT(create_date, '%Y-%m')
)
a
JOIN
(
SELECT
DATE_FORMAT(create_date, '%Y-%m') AS MONTH,
SUM(sum) AS total
FROM
(
SELECT
create_date ,
DATE_FORMAT(create_date, '%Y-%m') AS MONTH,
COUNT(*) AS sum
FROM
dmp_device_model
GROUP BY
create_date,
DATE_FORMAT(create_date, '%Y-%m')
)
ddm
GROUP BY
DATE_FORMAT(create_date, '%Y-%m')
)
b
ON
a.MONTH >= b.MONTH
group by
a.MONTH
联系客服
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1
MONTH是关键字，换一个列名。