通过返回多行MYSQL进行分组。

Question

表图：这里

我需要将来自total_serviços的所有值(2019年的年收入)与确定的cmc_emissor相加，cmc_emissor值对所有行都是相同的。

下面是我的代码和结果：

SELECT year(emissao) as 'Periodo', cmc_emissor, sum(total_serviços) as 'Total'
FROM nfpse
GROUP BY cmc_emissor, emissao
HAVING cmc_emissor = 'E000000';

结果：这里

预期结果：这里

Answer 1

SELECT cmc_emissor, year(emissao) as 'Periodo',
       sum(total_serviços) as 'Total'
FROM nfpse
WHERE cmc_emissor = 'E000000'
GROUP BY cmc_emissor, year(emissao)

Answer 2

你错过了组中的年份(Emissao)，它匹配完整的日期，包括日期和月份，因此给出了多个结果。

SELECT year(emissao) as 'Periodo', cmc_emissor, sum(total_serviços) as 'Total'
FROM nfpse
GROUP BY cmc_emissor, YEAR(emissao)
HAVING year(emissao) = '2019';

SQL文档日期和时间函数

年份()函数文档SQL