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