/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 vote190 views1 answer
Laravel wordpress reset password
PHP Laravel
0 vote226 views1 answer
Wpml language switcher shortcode
PHP
0 vote243 views1 answer
Php convert accented characters to html entities
PHP
0 vote216 views1 answer
Php connect
PHP
0 vote239 views1 answer
Laravel filesystem link
PHP Laravel
10 votes222 views3 answers
Check count in laravel
PHP
0 vote241 views1 answer
Migrate only one table laravel
PHP Laravel
1 vote196 views1 answer
Php text colors
PHP
0 vote236 views1 answer
Laravel find or fail exception
PHP
0 vote257 views2 answers
Laravel filemanger choose multiple images
PHP Laravel