我正在尝试按月份和年份分组计算实例数量。
我该如何制作这个表格呢:
SELECT
(MONTH(CAST(t1.some_date as DATE)) + ' ' + YEAR(CAST(t1.some_date as DATE))) as Issue_Month,
COUNT(*) as c
FROM
(sub query) t1
GROUP BY
(MONTH(CAST(t1.some_date as DATE)) + ' ' + YEAR(CAST(t1.some_date as DATE)))
错误行2:无法对bigint,varchar(1)应用“+”。
我尝试使用&
和||
替换+
来构建所需的字符串,但没有成功。
如何生成下面这样的表:
Month Year | c
我该如何制作这个表格呢:
Month | Year | c
||
而不是+
(我想)。 - forpas