/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 vote172 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
0 vote185 views1 answer
Check if any field update laravel
PHP Laravel
1 vote183 views2 answers
How to get data from a table in laravel
PHP Laravel
16 votes139 views2 answers
How to save information on pdf file in laravel project
PHP Laravel
17 votes254 views6 answers
Laravel auth user in constructor
PHP Laravel
1 vote226 views5 answers
Laravel modules
PHP Laravel
1 vote190 views2 answers
Laravel query builder sum
PHP Laravel
0 vote178 views1 answer
Laravel subtract date
PHP Laravel
1 vote184 views1 answer
Rtl file manager laravel
PHP Laravel
0 vote188 views1 answer
Copy file from one directory to another Laravel
PHP Laravel