Thank you very much Igor. This will do exactly what I need.
Igor Tandetnik wrote:
Lucas (a.k.a T-Bird or bsdfan3)
<[EMAIL PROTECTED]> wrote:
I am using SQLite in an application within a game where I have a table
of player nicknames and cumulative player scores (among other things).
How do I figure out at what (numeric) one of these records would be at
if the table were sorted, say, by the cumulative scores column?
select count(*) from tableName
where scrore > (select score from tableName where playerId = :player);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------