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
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
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
3 matches
Mail list logo