Query builder

How to make this query with QueryBuilder or what?

SELECT duznici_2018.*,sum(rate_2018.rata) as ukupno FROM duznici_2018 LEFT JOIN rate_2018 ON duznici_2018.duznikID=rate_2018.duznikID  GROUP BY duznikID DESC

I'm stuck on how to add SUM:

$sumrate = DB::table('duznicis')->leftJoin('rates', 'duznicis.kupac_id', '=', 'rates.duznik_id')->get();

rizwanjaved

8 years ago

Level 1

i think you can try using something like that expressions

->select(DB::raw('count(*) as user_count, status'))

in your query builder to get the desired results

BezhanSalleh

8 years ago

Level 25

$result = DB::table('duznicis')->leftJoin('rates', 'duznicis.kupac_id', '=', 'rates.duznik_id')
    ->select('duznicis.*',DB::raw('sum(table_name.column_name) as ukupno'))
    ->groupBy('table_name.column_name')
    ->get();

$sumrate = $result->ukupno;

//not tested but should work
$sumrate = DB::table('duznicis')->leftJoin('rates', 'duznicis.kupac_id', '=', 'rates.duznik_id')
    ->sum('table_name.column_name');

Please or to participate in this conversation.