laravel 报错信息SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is

报错信息SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP

 

1.

正确的SQL语句

$list = $query

// ->selectRaw(" SUM(pay_num) as pay_nums,SUM(pay_num)/SUM(login_num) as divpay_num "

// )

->select(

array(

\DB::raw('process_date as process_date'),

\DB::raw('SUM(login_num) as login_nums'),

\DB::raw('SUM(index_num) as index_num'),

\DB::raw('SUM(scan_num) as scan_num'),

\DB::raw('SUM(detail_num) as detail_num'),

\DB::raw('SUM(period_num) as period_num'),

\DB::raw('SUM(deduction_num) as deduction_num'),

\DB::raw('SUM(submit_lease_num) as submit_lease_num'),

\DB::raw('SUM(business_num) as business_num'),

\DB::raw('SUM(topay_num) as topay_num'),

\DB::raw('SUM(pay_num) as pay_nums'),

\DB::raw(