I was wondering something. I have a list of teams with points.
I want to get a specific team and get 2 team over and 2 team under the selected team. These teams are ordered by points.
select * from standing where team=15 order by points desc
so lets say team 15 is ranked 7 then i would like to show teams ranked from 5 to 9.
i dont know if this is all clear but i hope you understand what i mean!