多个sql怎么在数据集中执行

如图在数据库可以执行，放在数据集中报错，猜测是因为；识别成多个sql，要怎么解决？

FineReport CLY 发布于 2023-7-14 15:30

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答

CLYLv3见习互助
发布于2023-7-17 13:52

SELECT

DATE_FORMAT(DATE_ADD(DATE_ADD(LAST_DAY(CONCAT(${if(len(time) == 0,year(now()), year(time) )}, '-', ${if(len(time)== 0,format(month(now()),"00"), format(month(time),"00") )}, '-01')), INTERVAL 1 DAY), INTERVAL -(a.a + (10 * b.a) + (100 * c.a)) DAY), '%Y-%m-%d') AS date

FROM

(SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL

SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS a,

(SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL

SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS b,

(SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL

SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS c

WHERE

DATE_ADD(DATE_ADD(LAST_DAY(CONCAT(${if(len(time) == 0,year(now()), year(time) )}, '-', ${if(len(time)== 0,format(month(now()),"00"), format(month(time),"00") )}, '-01')), INTERVAL 1 DAY), INTERVAL -(a.a + (10 * b.a) + (100 * c.a)) DAY) >= CONCAT(${if(len(time) == 0,year(now()), year(time) )}, '-', LPAD(${if(len(time)== 0,format(month(now()),"00"), format(month(time),"00") )}, 2, '0'), '-01')

AND DATE_ADD(DATE_ADD(LAST_DAY(CONCAT(${if(len(time) == 0,year(now()), year(time) )}, '-', ${if(len(time)== 0,format(month(now()),"00"), format(month(time),"00") )}, '-01')), INTERVAL 1 DAY), INTERVAL -(a.a + (10 * b.a) + (100 * c.a)) DAY) <= LAST_DAY(CONCAT(${if(len(time) == 0,year(now()), year(time) )}, '-', ${if(len(time)== 0,format(month(now()),"00"), format(month(time),"00") )}, '-01'))

ORDER BY

date ASC;