/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 vote364 views1 answer
Laravel collection shift
PHP Laravel
2 votes338 views2 answers
Laravel sidebar menu active
PHP Laravel
0 vote347 views1 answer
Laravel access request in provider
PHP Laravel
1 vote321 views1 answer
How get the latest arraye value in laravel
PHP Laravel
2 votes345 views1 answer
Laravel mix purge css
PHP Laravel
1 vote350 views1 answer
Convert 1 digit to five digits laravel
PHP Laravel
0 vote346 views1 answer
Redirect 404 in laravel
PHP Laravel
0 vote350 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP Laravel
0 vote327 views1 answer
Return pdft download and back with msg in laravel
PHP Laravel
0 vote366 views1 answer
How to check if a url has a certain word in laravel
PHP Laravel