select 颜色,SUM(实发数量)
from helloapp_sheet1
where TO_DAYS(MAX(时间) - TO_DAYS(时间)=20
GROUP BY 颜色
出现错误:
select 颜色,SUM(实发数量)
from helloapp_sheet1
where TO_DAYS(MAX(时间) - TO_DAYS(时间)=20
GROUP BY 颜色
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY
颜色
' at line 4
时间: 0s