/PHP/Laravel/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

5 votes318 views1 answer
Laravel rate limit
PHP Laravel
0 vote365 views1 answer
Add another column in a table in laravel
PHP Laravel
6 votes348 views4 answers
Laravel base url
PHP Laravel
0 vote380 views1 answer
What is actullay work model in laravel
PHP Laravel
0 vote364 views1 answer
Laravel 6 use username instead of id
PHP Laravel
0 vote337 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
2 votes357 views1 answer
Path of app directory in controller laravel
PHP Laravel
0 vote365 views1 answer
Laravel eloquent relationships count
PHP Laravel
0 vote336 views2 answers
Add blade in blade laravel
PHP Laravel
2 votes359 views1 answer
Laravel upload image to public folder
PHP Laravel