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 <itandet...@mvps.org> 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; > > > 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 approach > would end up with. > -- > 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