SELECT DATENAME(YEAR, a.CreateTime)as Years,DATENAME(MONTH, a.CreateTime) AS XName,sum(JE+ PacketMoney)as Val
from Appointment a
where a.zt=6
GROUP BY DATENAME(YEAR, a.CreateTime),DATENAME(MONTH, a.CreateTime);
posted on
2022-05-23 10:03葉子牛牛
閱讀(86)
評(píng)論(0)
收藏舉報(bào)