Ok, Did that but now it doesn't run?
select * from (
select * from table1 where Field2='Red' order by Field1 limit 1
offset :X)
union all
select * from (
select * from table1 where Field2='White' and
Field1 < (select Field1 from table1 where Field2='Red' order by
Field1 limit 1)
order by Field1 desc limit 4
)
union all
select * from (
select * from table1 where Field2='Blue' and
Field1 < (select Field1 from table1 where Field2='Red' order by
Field1 limit 1)
order by Field1 desc limit 1
)
union all
select * from (
select * from table1 where Field2='White' and
Field1 > (select Field1 from table1 where Field2='Red' order by
Field1 limit 1)
order by Field1 limit 4
)
union all
select * from (
select * from table1 where Field2='Blue' and
Field1 > (select Field1 from table1 where Field2='Red' order by
Field1 limit 1)
order by Field1 limit 1
)
order by Field1;
I take it I am missing something here?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik
Sent: Sunday, November 30, 2008 9:15 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Select Limit issues
"Webmaster" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> Looping.
>
> Is there a way to put this into a loop where it starts again but with
> the
> next Field2 ='Red'
Replace all subqueries that look like this:
(select Field1 from table1 where Field2='Red'
order by Field1 limit 1)
with something like this:
(select Field1 from table1 where Field2='Red'
order by Field1 limit 1 offset :X)
and vary X in the loop, starting from 0, until you get an empty
resultset.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
