/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 vote335 views1 answer
Token capabilities in vault
PHP
5 votes385 views2 answers
Laravel - Send mail using mail class
PHP Laravel
3 votes347 views3 answers
Class 'App\Http\Controllers\Admin\Route' not found
PHP
3 votes332 views2 answers
How to create shortcode
PHP
0 vote322 views1 answer
How to run curl command through php script
PHP
40 votes301 views6 answers
Laravel 8 foreign key migration
PHP
6 votes265 views1 answer
Change website address wordpress
PHP
0 vote364 views1 answer
Laravel seed timestamps columns
PHP Laravel
2 votes384 views2 answers
Php remove non numeric
PHP
15 votes368 views4 answers
Php compare dates
PHP