我试图找到相同ID值的总和。
$tournament = Tournament::find($id);
$topTen = DB::table('match_scoreboard_batting')
->join('matches','match_scoreboard_batting.match_id','=','matches.id')
->where('matches.tournament_id',$id)
->select('match_scoreboard_batting.player_id','match_scoreboard_batting.runs')
->sum('match_scoreboard_batting.runs');
echo "<pre>";
print_r($topTen);
我知道所有ID运行总和。但是我怎么能找到同一个ID?
最佳答案
请尝试此查询。
$topTen = DB::table('match_scoreboard_batting')
->join('matches','match_scoreboard_batting.match_id','=','matches.id')
->where('matches.tournament_id',$id)
->select('match_scoreboard_batting.player_id', \DB::raw(' sum(match_scoreboard_batting.runs) as runs'));
您可以使用 :
来自laravel docs
DB::raw('SUM(price) as total_sales')
希望它对您有用。