ItSolutionStuff.com

Laravel Select with Sum Query Example

By Hardik Savani • November 5, 2023
Laravel

We mostly required to get sum of amount, salary etc in laravel. We can also get sum of column using mysql SUM(). We have two way to get sum of column value. first we can use laravel sum() of query builder and another one we can use with directly with select statement using DB::raw(). I give you both example you can see and use any one as perfect for you.

Example 1:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\UserProduct;

class DemoController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$userId = 1;

$amount = UserProduct::where('user_id', $userId)->sum('amount');

dd($amount);

}

}

Example 2:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Click;

use DB;

class DemoController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$data = Click::->select(DB::raw("SUM(numberofclick) as count"))

->orderBy("created_at")

->groupBy(DB::raw("year(created_at)"))

->get();

dd($data);

}

}

I hope it can help you...

Tags: Laravel
Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

Laravel Search Case Insensitive Query Example

Read Now →

Laravel Eloquent selectRaw() Query Example

Read Now →

Laravel Eloquent orderByRaw() Query Example

Read Now →

Laravel Eloquent Where Query Examples

Read Now →

Laravel Eloquent orWhere() Condition Example

Read Now →

Laravel Eloquent WhereIn Query Example

Read Now →

How to use Union Query with Laravel Eloquent?

Read Now →

How to Get Query Strings Value in Laravel?

Read Now →

Laravel Query Builder Where Exists Example

Read Now →

Example of unionAll in Query Builder Laravel

Read Now →

Laravel Join with Subquery in Query Builder Example

Read Now →