mysql - 如何获得 Laravel 中相同 id 值的总和？

Question

我正在尝试查找相同 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 值的总和呢？

Answer 1

请尝试此查询。

$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')

希望它对您有用。