CODEWITHSUNDEEP
phpmysqlsqllaravel
user8338151
user8338151

Reputation: 113

Laravel get sum of sql query

I'm using laravel framework, very newbie with it. I have multiple records in my php application, something like this: 

"[{"balance":20,"account_number":"1"},
{"balance":80,"account_number":"1"}
{"balance":20,"account_number":"2"}]"

I need to SUM the total balance of account_number.

So it should be: 

account_number1 - balance 100
account_number2 - balance 20

I have tried 

>>> $orders = DB::table('demo_trades')->select('balance', DB::raw('SUM(balance)'))->groupBy('account_number')->get()->toJson();

How I can do it?

Upvotes: 2

Views: 596

Answers (2)

user8338151
user8338151

Reputation: 113

Ok thx guys how helped me

i did it

$users = DB::table('demo_trades')->select(DB::raw('sum(balance) as balance, account_number'))->groupBy('account_number')->get()->toJson();

Upvotes: 1

Bilal Ahmed
Bilal Ahmed

Reputation: 4066

You need Laravel Aggregates queries

$orders = DB::table('demo_trades')
        ->sum('demo_trades.balance')
        ->groupBy('account_number')->get();

Upvotes: 0

Related Questions