Gah, I spent all morning wracking my brains to fix a rendering order batching bug (fixed! yay!), and now I suddenly have a second daily headache with some SQL. If you use SQL a lot you can probably tell me how trivial this is…<\/p>\n
Imagine a table of scores<\/p>\n
Dave\u00a0 PlanetA 4,200<\/p>\n
Mike PlanetB 2,200<\/p>\n
Dave PlanetA 4,100<\/p>\n
Chas Planet A, 7,200<\/p>\n
And so on. What I am doing right now is a SELECT to get the top 20 rows from this table where the planet is (for example ) PlanetA. What I *want*n to do is to get the top 20 rows, but only the TOP entry for each player. So you only appear once in each high score list.<\/p>\n
I can’t get my head around how to do that. I want something like SELECT * FROM scores WHERE scores.planet == ‘zog’ AND scores.score IS HIGHEST FOR score.player ORDER BY score<\/p>\n
But of course I’ve made that syntax up and its imaginary. Albeit cool.<\/p>\n
Tell me there is an easy way to do this thang?<\/p>\n
And ooh guest what! Democracy 3 is the #1 strategy game on the ipad right now, due to a rather insane price drop I’m experimenting with…<\/p>\n","protected":false},"excerpt":{"rendered":"
Gah, I spent all morning wracking my brains to fix a rendering order batching bug (fixed! yay!), and now I suddenly have a second daily headache with some SQL. If you use SQL a lot you can probably tell me how trivial this is… Imagine a table of scores Dave\u00a0 PlanetA 4,200 Mike PlanetB 2,200<\/p>\n