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

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')

Similar codes

10 votes255 views3 answers
For loop in laravel
PHP Laravel
0 vote252 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
1 vote224 views1 answer
How delete the table in laravel in the commend
PHP Laravel
9 votes231 views4 answers
Composer laravel ui
PHP Laravel
2 votes277 views6 answers
Get last id in laravel
PHP Laravel
0 vote224 views1 answer
Check null if string laravel
PHP Laravel
2 votes254 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP Laravel
0 vote223 views1 answer
Laravel media library regenerate
PHP Laravel
1 vote233 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
1 vote203 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel