Question : select sum in laravel
Answered by : lokesh-ramchandani
Sometime for such queries you need to disable the strict check So inside config/database.php and inside mysql, Set 'strict' => false,
->select('user_id', DB::raw('SUM(points) as total_points'))
Source : | Last Update : Thu, 20 Aug 20
Question : select sum laravel
Answered by : muhindo-mubaraka
MyModel::where('user_id', $_some_id)->sum('amount')
Source : | Last Update : Wed, 22 Jun 22
Question : laravel select where with total sum query to get all data with sum
Answered by : kind-koala-iaqze1qxk6vt
$query = SalesPayment::select('*', \DB::raw('SUM(amount) AS total_sale_amount')->with ....
Source : https://stackoverflow.com/questions/59526950/how-to-get-sum-along-with-this-laravel-eloquent-query | Last Update : Mon, 11 Apr 22