Thursday, February 1, 2018

How to display all column in group by - development

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

Query Table imageBobotteam 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