/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

5 votes241 views2 answers
Check session in blade laravel
PHP Laravel
0 vote227 views1 answer
How to cooncet dabase eith laraavel
PHP
3 votes199 views3 answers
Php print array nice format
PHP
2 votes205 views1 answer
Php file_get_contents disable ssl check
PHP
0 vote198 views1 answer
Lity in Wordpress
PHP
0 vote183 views1 answer
Wp table with hostname setup
PHP
0 vote215 views1 answer
HASHING in php double scripting
PHP
1 vote208 views1 answer
How to mantain text in form after error php
PHP
0 vote212 views2 answers
Laravel collection remove duplicates
PHP Laravel
29 votes190 views1 answer
Php generate random string fixed length
PHP