Re: [sqlite] Select Limit issues

[Alexey Pechnikov]

Hello!

В сообщении от Sunday 30 November 2008 23:19:52 Igor Tandetnik написал(а):
> Personally, I'd implement logic like this in my application code, rather
> than in ever-more-complex SQL statements.

May be as

create temp table A;

insert into A
    select * from table1 where Field2='Red' order by Field1 limit 1;

insert into A
    select * from table1 where Field2='White' and
    Field1 < (select Field1 from A where Field2='Red')
    order by Field1 desc limit 4;

insert into A
    select * from table1 where Field2='Blue' and
    Field1 < (select Field1 from A where Field2='Red')
    order by Field1 desc limit 1;

insert into A
    select * from table1 where Field2='White' and
    Field1 > (select Field1 from A where Field2='Red')
    order by Field1 limit 4;

select * from A
order by Field1;


Best regards, Alexey.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users