/PHP/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 vote234 views1 answer
Image watermark on image laravel 8
PHP Laravel
0 vote194 views2 answers
Laravel model column default value
PHP Laravel
2 votes169 views1 answer
Php unset reference
PHP
0 vote226 views1 answer
If is gutenberg page php wp
PHP Wordpress
11 votes186 views5 answers
Laravel redirect back url with message
PHP
6 votes175 views1 answer
Laravel Route::group definition
PHP
3 votes216 views2 answers
Laravel 7 view @php
PHP Laravel
2 votes183 views4 answers
How to create controller inside folder in laravel
PHP
0 vote202 views1 answer
How to pass parameter to middleware laravel 8
PHP
0 vote177 views1 answer
Php build query from array
PHP