/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

0 vote227 views1 answer
Laravel new line in session flash message
PHP Laravel
10 votes229 views4 answers
In random order laravel
PHP Laravel
0 vote262 views1 answer
Laravel db query log string replacements
PHP Laravel
15 votes209 views6 answers
Laravel migration default value
PHP Laravel
12 votes217 views3 answers
Call controller function from another controller laravel
PHP Laravel
0 vote211 views1 answer
Menyimpan get di laravel
PHP Laravel
2 votes238 views2 answers
Laravel switch
PHP Laravel
2 votes220 views1 answer
Path of app directory in controller laravel
PHP Laravel
1 vote274 views3 answers
Laravel invoice toturial
PHP Laravel
0 vote211 views1 answer
How to develop package beside laravel project
PHP Laravel