/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 vote168 views1 answer
\r in php
PHP
0 vote148 views4 answers
Get_adjacent_post wordpress
PHP
0 vote169 views2 answers
How to separate date and time in laravel
PHP Laravel
0 vote164 views1 answer
Laravel controller create command in a folder
PHP Laravel
0 vote164 views1 answer
ErrorException Undefined index(laravel 7 array helpers)
PHP
0 vote186 views2 answers
Insert multiple rows laravel
PHP Laravel
28 votes158 views5 answers
Laravel whereRaw
PHP
0 vote183 views1 answer
Laravel deploy without moving public directory
PHP Laravel
12 votes161 views4 answers
Count in laravel'
PHP Laravel
0 vote170 views1 answer
Generate unique order id in php
PHP