Answers for "laravel order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in group by"

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 order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in group by"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Answers for "laravel order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in group by"

Code answers related to "laravel order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in group by"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Answers for "laravel order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in group by"

Code answers related to "laravel order by clause is not in group by clause and contains nonaggregated column 'cms.posts.created_at' which is not functionally dependent on columns in 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