forums.marpirc.net

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?
<p>

Chris.

--
chris_moore@mail.com

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

<p>

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

<p>

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.

--
churritz@cts.com