Find maximum score by each player with each team
select distinct team_innings,batsman_name ,max(runs)
from batting_summary
group by team_innings,batsman_name
order by max(runs) desc
limit 5;
I want, one player from each team who score maximum
Find maximum score by each player with each team
select distinct team_innings,batsman_name ,max(runs)
from batting_summary
group by team_innings,batsman_name
order by max(runs) desc
limit 5;
I want, one player from each team who score maximum
Copyright © 2021 Jogjafile Inc.