Answers for "laravel eloquent query join select list is not in group by clause and contains nonaggregated column 'reviews.s.id' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by"

PHP

Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel

1. set strict to false in config/databtase.php 
2. ->select([
		'exam_registrations.id',
        'exam_registrations.exam_id',
        'exam_registrations.user_id',
        DB::raw('sum(submissions.marks) as totalMarksGained')
     ])
     ->groupBy('exam_registrations.user_id')
     ->orderBy('totalMarksGained', 'DESC')

Posted by: Guest on August-12-2020

Code answers related to "laravel eloquent query join select list is not in group by clause and contains nonaggregated column 'reviews.s.id' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "laravel eloquent query join select list is not in group by clause and contains nonaggregated column 'reviews.s.id' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by"

Code answers related to "laravel eloquent query join select list is not in group by clause and contains nonaggregated column 'reviews.s.id' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us