mysql - 连接具有相同用户的行

Question

我有一个疑问:

SELECT e.id_taxe
     , u.nm_user
     , dt_taxe
     , SUM(e.vl_taxe) as vl_taxe
FROM taxe as e 
  JOIN user as u 
    ON u.id_user = e.id_user 
WHERE id_enterprise = 86 
   AND dt_taxe BETWEEN '2017-01-01' AND '2017-03-31'
   AND lg_cancel = 0 
 GROUP 
    BY e.dt_taxe
     , e.id_user 
 ORDER 
    BY e.id_user
     , e.dt_taxe

结果，我有:

id_taxe     nm_user   dt_taxe      vl_taxe
728         Maria     2017-01-01   17091.07048034668
727         Maria     2017-02-01   14091.07048034668
721         Maria     2017-03-01   1021.07048034668
731         Pedro     2017-01-01   16353.569854736328
732         Pedro     2017-02-01   6353.56231239

如何连接行以获得结果:

id_taxe     nm_user   dt_taxe      vl_taxe
728         Maria     2017-01-01   17091.07048034668 , 
                      2017-02-01   14091.07048034668,
                      2017-03-01   1021.07048034668
731         Pedro     2017-01-01   16353.569854736328,
                      2017-02-01   6353.56231239

Answer 1

对于像 PostgreSQL 这样的数据库，这可以通过窗口函数来完成，但 MySQL 不支持窗口函数，所以你不能这样做