I'm not 100% sure this is what you're asking for, but try this...
CREATE TABLE foo(Ranking INTEGER PRIMARY Key, Col1, Col2, ... );
INSERT INTO foo SELECT ... ORDER BY ...;
SELECT * FROM foo WHERE Ranking BETWEEN x AND y;
Warnings in the documentation aside, this will give you the rows in
th
Igor Tandetnik wrote:
> "Ian Walters" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>> What I'm trying to do is create an ordered table in SQLite that I can
>> then look up by row number. If performance isn't considered this is
>> actually quite easy. For example
>>
>> CREATE TEMP
Igor Tandetnik <[EMAIL PROTECTED]> writes:
> See if this helps:
>
> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>
> Igor Tandetnik
Igor,
These handy articles need linking from the main Documentation page(s) !
They are really "how-to-use" information.
Or have I missed a reference some
"Ian Walters" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> What I'm trying to do is create an ordered table in SQLite that I can
> then look up by row number. If performance isn't considered this is
> actually quite easy. For example
>
> CREATE TEMPORARY TABLE mytable AS ... comp
Ian Walters <[EMAIL PROTECTED]> writes:
>
> Hi,
>
> What I'm trying to do is create an ordered table in SQLite that I can
> then look up by row number. If performance isn't considered this is
> actually quite easy. For example
>
> CREATE TEMPORARY TABLE mytable AS ... complex select statement
5 matches
Mail list logo
