Laravel get sum of sql query

Question

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?

You can use aggregate function predefined in DB like this DB::table('demo_trades')->sum('balance')->groupBy('account_number')->get()->toJson(); — Saad Suri
– Saad Suri, Commented Dec 27, 2017 at 10:56

user8338151 · Accepted Answer · 2017-12-27 12:07:47Z

1

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();

answered Dec 27, 2017 at 12:07

user8338151

1131 gold badge1 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcin Nabiałek · Accepted Answer · 2017-12-27 11:44:05Z

0

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

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

answered Dec 27, 2017 at 11:03

Bilal Ahmed

4,0663 gold badges25 silver badges42 bronze badges

@BillalAhmed i have got PHP Error: Call to a member function groupBy() on float on line 1