Response to Which Game to Target Next?

if you had a table with collumns player and score you could do this to get the closest score difference above you.

select a.player,min(b.score-a.score) from table a,table b where b.score>a.score group by a.player;

i can't remember to much else baout group by, but i think you could get the player that owns the closest score by another super select and group by.

[ Previous | Next ]