/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 vote277 views1 answer
Laravel get all users except role spatie
PHP
7 votes339 views2 answers
Laravel how to check if there are record exists
PHP Laravel
0 vote290 views1 answer
Uft8 json php
PHP
3 votes311 views4 answers
Codeigniter apache remove index.php
PHP
1 vote292 views1 answer
Unable to call component method. Public method [gotoPage] not found on component
PHP
0 vote377 views1 answer
How to disable opcache
PHP
0 vote395 views2 answers
Wordpress move debug.log
PHP Wordpress
6 votes336 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
3 votes362 views6 answers
Jwt for Laravel
PHP
0 vote300 views1 answer
Php timestamp to iso8601
PHP