Laravel query builder sum

Select sum in laravel

Sometime for such queries you need to disable the strict check
 So inside config/database.php and inside mysql, 
 Set 'strict' => false,

->select('user_id', DB::raw('SUM(points) as total_points'))

Laravel query builder sum

$purchases = DB::table('transactions')
    ->join('categories', 'transactions.category_id', '=', 'categories.id')
    ->where('categories.kind', '=', 1)
    ->sum('transactions.amount');

Source: stackoverflow.com

Similar codes

4 votes318 views1 answer
Get client size in laravel
PHP Laravel
0 vote289 views2 answers
Laravel insert multiple rows from form
PHP Laravel
8 votes277 views1 answer
Last query in laravel
PHP Laravel
4 votes268 views4 answers
Search in laravel 8
PHP Laravel
10 votes264 views2 answers
Laravel list routes
PHP Laravel
10 votes326 views3 answers
For loop in laravel
PHP Laravel
12 votes287 views2 answers
Timestamp false in laravel
PHP Laravel
0 vote311 views1 answer
Avg rating get in join in laravel 8
PHP Laravel
1 vote229 views1 answer
Laravel pluck multiple columns
PHP Laravel
0 vote294 views2 answers
Laravel validation exact string length
PHP Laravel