sql groupby 不起作用，我想按 code_branch 分组

Question

->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameascompany_name','d.nameasproject_name','f.nameasregion_name','e.codeasbranch_code','e. idasbranch_code',DB::raw('

P粉428986744 · Answer

转到config/database.php

严格设置为 false

P粉154798196 · Answer

这是不正确的，您不能对同一列使用单个名称，

'e.code as branch_code',
  'e.id as branch_code',

更改为

'e.code as branch_code',
  'e.id as branch_id',