Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

UsmanBasharmal's avatar

Mysql Raw query with groupBy in laravel

Is there any better way of using Eloquent or Query builder

        $PurchasesdAmount = DB::select(
            'SELECT pp.supplier_id,SUM(pp.amount)AS PaidAmount,pp.id,
            (SELECT NAME FROM suppliers sa WHERE sa.id = pp.supplier_id) AS Supplier
            FROM purchases_payments pp 
            Group BY pp.supplier_id'
        );
        return response()->json(['data' => $PurchasesdAmount]);
0 likes
0 replies

Please or to participate in this conversation.