On Fri, Oct 01, 2010 at 08:37:07PM +0100, Andy Chambers wrote: > Given the following.... > > create table events ( > id, > date, > status > ); > insert into events values ('001','a','N'); > insert into events values ('001','b','N'); > insert into events values ('001','c','Y'); > insert into events values ('001','d','N'); > insert into events values ('001','e','Y'); > insert into events values ('001','f','Y'); > insert into events values ('001','g','N'); > > Is it possible, using plain SQL, to derive the following > > 001,c,d > 001,e,g
It'd be easier, I think, if you had a monotonically increasing (always by one) unique numeric column. The you could do a select for rows in events where the value for that column is between two values which are sub-queries for immediately preceding and following rows in the same table and where the status differs from that of the row in the top-level query. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users