Re: [sqlite] EXT : find sequential groups

2012-10-16 Thread Bart Smissaert
Yes, that should be 4 groups, marked with 1, 2, 3 and 4. RBS On Tue, Oct 16, 2012 at 11:15 PM, Igor Tandetnik wrote: > On 10/16/2012 6:08 PM, Black, Michael (IS) wrote: >> >> Do this work for you? >> >> CREATE TABLE Groups (Value); >> insert into Groups select distinct(Value) from test; > > > S

Re: [sqlite] EXT : find sequential groups

2012-10-16 Thread Igor Tandetnik
On 10/16/2012 6:08 PM, Black, Michael (IS) wrote: Do this work for you? CREATE TABLE Groups (Value); insert into Groups select distinct(Value) from test; Since the OP mentioned "sequential groups", I assumed that a sequence like "A,A,B,B,A,A,B,B" should count as four groups, not two as your

Re: [sqlite] EXT : find sequential groups

2012-10-16 Thread Black, Michael (IS)
Do this work for you? CREATE TABLE Test(ID,Value,Group_Marker); INSERT INTO "Test" VALUES(1,'D',0); INSERT INTO "Test" VALUES(2,'X',0); INSERT INTO "Test" VALUES(3,'X',0); INSERT INTO "Test" VALUES(4,'X',0); INSERT INTO "Test" VALUES(5,'A',0); INSERT INTO "Test" VALUES(6,'B',0); SELECT * FROM Test