/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

1 vote304 views1 answer
How laravel return the old value
PHP Laravel
4 votes217 views1 answer
TRANSACTON LARAVEL QUERY BUILDER
PHP Laravel
1 vote195 views1 answer
Invalid datetime format laravel
PHP Laravel
0 vote184 views1 answer
Laravel curl request
PHP Laravel
1 vote223 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
6 votes240 views3 answers
Laravel ide-helper
PHP Laravel
0 vote201 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel
11 votes193 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
0 vote189 views2 answers
Laravel undefined index
PHP Laravel
-1 vote191 views1 answer
Laravel merge two arrays helper
PHP Laravel