How To Select with Sum Query In Laravel 8?

Laravel 8 , Laravel 7 , Laravel , Laravel 6

Nicesnippets

726

16-11-2021


How To Select with Sum Query In Laravel 8?

Hi Friends,

Most of us mostly need to get the sum of few numbers ,visitor,or others in laravel application. Today now in this post i will show you How to Select with Sum Query in Laravel? We can easily get the sum of column by using mysql SUM(). So we have two way to get the sum of any column value.At first one is we can do by use laravel sum() of query builder and another one is do directly with select statement by using DB::raw().

Here I will give you both example. So we can see and also use any one as perfect for us.

Example 1 :


$data = DB::table("users")->sum('student_marks');

print_r($data);

Example 2 :

$data = DB::table("users")

->select(DB::raw("SUM(student_marks) as count"))

->orderBy("created_at")

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

->get();

print_r($data);

I hope it help you...


Recommended Posts