/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

3 votes200 views2 answers
Laravel 8 Target class [FormController] does not exist.
PHP Laravel
0 vote212 views1 answer
Laravel htaccess for aws ec2
PHP Laravel
0 vote198 views1 answer
How to stop message of laravel mix
PHP Laravel
0 vote220 views1 answer
Laravel creating_table_name
PHP Laravel
1 vote240 views1 answer
Laravel select all except some columns
PHP Laravel
0 vote199 views1 answer
Explode in laravel blade
PHP Laravel
2 votes199 views1 answer
Custom rule laravel validation
PHP Laravel
0 vote209 views1 answer
Current time input field in laravel form
PHP Laravel
0 vote208 views4 answers
Laravel 8: bootstrap
PHP Laravel
1 vote251 views3 answers
Create new laravel project with specific version
PHP Laravel