/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

8 votes265 views1 answer
The best way to learn php
PHP
0 vote276 views1 answer
Php check if post file is empty
PHP
0 vote272 views1 answer
Infyom Generate From Table
PHP
0 vote262 views1 answer
Retrievemultipleimage from database in laravel
PHP
0 vote322 views1 answer
Laravel scheduler on shared hosting
PHP Laravel
1 vote328 views1 answer
Laravel emial unique igration error
PHP Laravel
14 votes268 views3 answers
Php carbon from timestamp
PHP
3 votes306 views1 answer
Back route laravel
PHP Laravel
0 vote313 views1 answer
Provide filter condition in autocomplet field in drupal form using property
PHP
4 votes276 views3 answers
Install php7.4 linux
PHP