使用分页器的时候,若 select 语句包含聚合函数,则无法正常 select
运行以下语句,会报错。
$builder->select([
\DB::raw("case when /* some condition */ then /* do something */ else /* do another thing */ end field_1"),
\DB::raw("count(1) field_2")
])->groupBy('field_1')
->paginate();
Unknown column 'field_1' in 'group statement' (SQL: select count(*)
as aggregate from table where is_enable = 1 group by field_1)
推荐文章: