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('SUM(pay_num)/SUM(login_num) as divpay_num'),

)

)

->groupBy('process_date')

->offset($page)

->limit($limit)

->get()

->toArray();

 

2. 错误分析：、主要是重名了，

\DB::raw('SUM(pay_num) as pay_nums') 中，不能在下面使用 \DB::raw('pay_nums/login_nums as divpay_num'),

 

错误写法：

 

 

3. \DB::raw('SUM(pay_num)/SUM(login_num) as divpay_num'),

这是正确的写法

 

 

 

如有疑问，联系微信 18201191697