How to display all column in group by
I have two tables team
and bobotteam
, and then I was try this query:
SELECT team.id , bobotteam.teamfight/MAX(bobotteam.teamfight)
FROM team
INNER JOIN bobotteam on team.id = bobotteam.id
Why data only show 1 data even though I have two data in the bobotteam
table.
IMAGE
from Laravel Questions and Answers https://laravelquestions.com/php/how-to-display-all-column-in-group-by/
via Lzo Media
No comments:
Post a Comment