/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

44 votes334 views6 answers
How to make controller in laravel
PHP
0 vote375 views1 answer
Php check if two arrays are equal
PHP
0 vote339 views2 answers
Collection get first element laravel
PHP Laravel
0 vote298 views1 answer
Count files in folder php
PHP
1 vote364 views3 answers
Unique check two clolumn in laravel validation
PHP
18 votes426 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
0 vote356 views1 answer
Wp automatic-feed-links
PHP
24 votes426 views6 answers
Laravel create model
PHP Laravel
0 vote373 views1 answer
Throws php
PHP
0 vote352 views1 answer
Laravel foreach localstorage
PHP