I can find the number of runs a batsman scored in every match by ``` select b.match_id,b.batsman,sum(b.batsman_runs) from balls as b inner join matches m on b.match_id=m.match_id where m.method='D/L' group by b.match_id, b.batsman order by sum(b.batsman_runs) desc; ```
The result |match_id| batsman|sum(batsman_runs)| | 980999| V Kohli| 113| | 829743| DA Warner| 91| | 392214| ML Hayden| 89| | 1136578| CA Lynn| 74| | 336025| Salman Butt| 73| | 980999| CH Gayle| 73| | 1136592| RR Pant| 69| | 1136592| JC Buttler| 67| | 1136578| CH Gayle| 62| | 1136578| KL Rahul| 60| But I need the top scorer of every match, how can I get that?They are similar match_id in result set
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)