Which Game to Target Next?

greenspun.com : LUSENET : MAME Action Replay : One Thread

I've made recordings on all 8 of the T4 games. Most of my scores are pretty dreadful, but that's to be expected. I'm wanting to know if there's an easy way to see in which game my score is closest to the score above it. Ideally, I'd like to be able to list all my T4 scores in order of the ratio of their score to the score above them (if you see what I mean), but I thought I'd already made some way of doing something close to this?

Chris.

-- Chris Moore (chris_moore@mail.com), June 01, 2000

Answers

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.

-- Chad (churritz@cts.com), June 02, 2000.


Moderation questions? read the FAQ