Re: [sqlite] can you speed this query up?

[A. Pagaltzis]

* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2006-05-23 02:35]:
> What you have to do is:
> 
>    SELECT qi, ri, drl, score
>      FROM ...
>     WHERE score=(SELECT max(score) FROM ...)

Actually, in cases such as this, the easiest approach is to use
`LIMIT`:

    SELECT qi, ri, drl, score
    FROM ...
    WHERE ...
    ORDER BY score DESC
    LIMIT 1

Regards,
-- 
Aristotle Pagaltzis // <http://plasmasturm.org/>