Hey guys. I'm kind of revisiting something I asked about before. I
have a high scores table, and a table of friends, and I wish to select
for user x:
The score of x
The scores of all of x's friends
Ordered by score descending.
I am using this:
SELECT * FROM (SELECT * FROM cupPlayTable
On 18 Oct 2010, at 4:09pm, Ian Hardingham wrote:
I also want to add selecting the highest score, and adding it to the
results assuming it isn't already in there (ie unless it happens your or
a friends' score is the highest). Could anyone advise me on how best to
do that?
Can you not do
Thanks Simon.
I have a further question on this topic.
I would like to find out where my user ranks amongst all scores - so I want to
SELECT name, score FROM scoreTable WHERE id=x
And then I wish to know how many rows occur before the one where user=myuser.
I can loop through them in code,
Hey guys.
I have a query which is very slow, and was wondering if there was any
advice you guys had on it.
Here are two table definitions:
CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY
AUTOINCREMENT, name TEXT NOT NULL UNIQUE, ranking TEXT, score REAL,
record TEXT);
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 01:54 AM, Ian Hardingham wrote:
And here is my query (written in a script language):
Are you actually getting correct answers from this?
upper('?')
Unless your script language includes a SQL parser, that does not do what you
think
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: sábado, 10 de julho de 2010 17:39
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Query critique
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 01:54 AM, Ian Hardingham wrote:
And here is my query
Hey guys.
I have a query which is very slow, and was wondering if there was any
advice you guys had on it.
Here are two table definitions:
CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY
AUTOINCREMENT, name TEXT NOT NULL UNIQUE, ranking TEXT, score REAL,
record TEXT);
On Fri, Jul 9, 2010 at 11:08, Ian Hardingham i...@omroth.com wrote:
Hey guys.
I have a query which is very slow, and was wondering if there was any
advice you guys had on it.
Here are two table definitions:
CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY
If you had the following tables
Table PEOPLERANKINGS(personid INTEGER PRIMARY KEY, personname TEXT, ranking)
Table FRIENDS(personid1, personid2)
and an index on
PEOPLERANKINGS.ranking
and FRIENDS.personid1,FRIENDS.personid2 is a composite unique primary key
You could get the top 10