在MySQL查询中可以按参数更改组吗?例如,如果用户在下拉列表中按“周”选择期间,则按周将结果分组,如果“月”则按月分组,与“年份”相同。week, MONTH(like_date) as month, YEAR(like_date) as year GROUP BY date";
在这个查询中,我只按日期分组是否可以使用CASE内部查询按参数更改组?
SELECT DISTINCT MonthName(Month([Date])) AS [Month], tblSupportCalls.System, Count(tblSupportCalls.System) AS [Total for System], Year([Date]) AS [Year]WHERE (((tblSupportCalls.Date) Between Now() And Now()-7) AND ((tblSupportCalls.System) In ('Career Campus','E-PEE