/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

1 vote325 views1 answer
How to add an custom error to validater error in laravel
PHP
0 vote274 views1 answer
Cách nhúng php vào html
PHP
0 vote262 views1 answer
Wordpress create post programmatically
PHP Wordpress
1 vote285 views1 answer
Laravel 8 validation required if another field is not null
PHP
9 votes280 views5 answers
Laravel exist
PHP Laravel
0 vote236 views1 answer
Laravel collection transform
PHP
23 votes266 views2 answers
Serve php file
PHP
0 vote316 views1 answer
Cloudinary laravel
PHP Laravel
12 votes282 views3 answers
For else laravel
PHP Laravel
19 votes289 views2 answers
PHP auto refresh page
PHP