我试图找到相同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')


希望它对您有用。

09-30 17:06
查看更多