Hello All!
i have a mySql table with those fields:
id
teamID
games
wins
draws
loses
goalsFor
goalsAgainset
points
they are all integers.
now, i want to show a list of teams to be ordered like that:
- by points - DESC (no problem to do this query).
- and here is my difficult: if more then 1 team have the same points, i need the team that have height goal difference (which mean to make a substraction of: goalsFor - goalsAgainset) to be ranked higher in the result.
does anyone know how?